https://community.jmp.com/t5/Discussions/Convert-into-nearest-hours-from-duration-hour-min-sec-format/m-p/551574#M76738 <P>If your Column 1 is correctly formatted something like this might work (most likely there simpler formulas to use)</P> <PRE><CODE class=" language-jsl">InHours(Hour(InHours(Hour(:Column 1) + If(Minute(:Column 1) &gt;= 30, 1, 0))))</CODE></PRE> Sat, 01 Oct 2022 12:36:13 GMT jthi 2022-10-01T12:36:13Z https://community.jmp.com/t5/Discussions/Convert-into-nearest-hours-from-duration-hour-min-sec-format/m-p/551553#M76737 <P>Hi JMP User.</P><P>&nbsp;</P><P>how to extract hours from the duration ( hr.min) format and round the min into the hours</P><P>&nbsp;</P><P>example:</P><P>20.45&nbsp; &nbsp;:&nbsp; &nbsp; I want 21:00:00</P><P>23.4&nbsp; : I want 00:00:00</P><P>4.5&nbsp; : I want 05:00:00</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="chandankishor66_0-1664626361641.png" style="width: 400px;"><img src="https://community.jmp.com/t5/image/serverpage/image-id/45957i4CCA6CC3EF392CC9/image-size/medium?v=v2&amp;px=400" role="button" title="chandankishor66_0-1664626361641.png" alt="chandankishor66_0-1664626361641.png" /></span></P><P>Regards</P><P>&nbsp;</P> Fri, 09 Jun 2023 15:59:28 GMT https://community.jmp.com/t5/Discussions/Convert-into-nearest-hours-from-duration-hour-min-sec-format/m-p/551553#M76737 chandankishor66 2023-06-09T15:59:28Z https://community.jmp.com/t5/Discussions/Convert-into-nearest-hours-from-duration-hour-min-sec-format/m-p/551574#M76738 <P>If your Column 1 is correctly formatted something like this might work (most likely there simpler formulas to use)</P> <PRE><CODE class=" language-jsl">InHours(Hour(InHours(Hour(:Column 1) + If(Minute(:Column 1) &gt;= 30, 1, 0))))</CODE></PRE> Sat, 01 Oct 2022 12:36:13 GMT https://community.jmp.com/t5/Discussions/Convert-into-nearest-hours-from-duration-hour-min-sec-format/m-p/551574#M76738 jthi 2022-10-01T12:36:13Z