round down time to hours

[#1]

Hi, how can I round down time 'hh:mm' to hours? eg. 07:55 will round down to '07:00'

Thanks.

[peterwh · Accepted solution]

Hi,

I don't know, if there's a simplier solution, but "maketime(hour(<TimeField>))" should do the trick. If you only set the format, the value stays at 07:55, it's only displayed as 07:00.

Kind regards

Peter

[ashfaq_haseeb]

Hi,

Try below

=hour(ceil(time#('07:55','hh:mm'),1/24))

Regards

ASHFAQ