Convert into nearest hours from duration ( hour:min:sec) format

[#1]

Hi JMP User.

how to extract hours from the duration ( hr.min) format and round the min into the hours

example:

20.45   :    I want 21:00:00

23.4  : I want 00:00:00

4.5  : I want 05:00:00

chandankishor66_0-1664626361641.png

Regards

[#2]

If your Column 1 is correctly formatted something like this might work (most likely there simpler formulas to use)

InHours(Hour(InHours(Hour(:Column 1) + If(Minute(:Column 1) >= 30, 1, 0))))