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
Regards
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))))