what measure do I use to create a calculated column with time range?

[RSSILVA_22]

Example:
hour column in hh:mm:ss format

calculated column should show
01:00 whatever is in the field time between 00:00:00 and 00:59:59

calculated column should show 02:00 whatever is in the time field between 01:00:00 and 01:59:59

Does anyone know how to write this measurement?

[AlexisOlson · Accepted solution]

Here's one possibility:

CalCol = TIME ( ROUNDUP ( Table1[Time] * 24, 0 ), 0, 0 )

[RSSILVA_22]

Thank you