Time rounding formula

[alex_gibson0111]

I want to ask if there is a time rounding formula?, if I input data between 10.00 - 10.59 the data will be recorded at 10.00, if I input data at 11.00 - 11.59 the data will be recorded at 11.00, some help is greatly appreciated, thanks

[Suvrutt_Gurjar · Accepted solution]

Please try

TIME(HOUR(0&[TimeIn])&":00")

Where [TimeIn] is the column containing time input such as 10:00 - 10:59 or 11:00-11:59 you have mentioned.

[alex_gibson0111]

Suvrutt_Gurjar:

TIME(HOUR(0&[TimeIn])&":00")

thanks for the respon, i will try

[alex_gibson0111]

it work thanks @Suvrutt_Gurjar