topic Re: Extract hours to the nearest hours from duration ( hour:min) format in Discussions

Extract hours to the nearest hours from duration ( hour:min) format

sweetycha — Sat, 10 Jun 2023 23:15:20 GMT

Hi Guys

how to extract hours from the duration ( hr:min) formant and round the min into the hours

example:

15:26 : 15 hours and 26 min

I want : 15

16:38: 16 hours and 38 mins

I want :17 as 38 min is over 30 mins

Appreciate your help

Re: Extract hours to the nearest hours from duration ( hour:min) format

txnelson — Sun, 28 Jun 2020 19:39:13 GMT

Here is how I do it

Names Default To Here( 1 );

time=informat("15:22:00","h:m:s");
show(format(round(time/inhours(1))*3600,"h:m:s"));

time=informat("10:49:00","h:m:s");
show(format(round(time/inhours(1))*3600,"h:m:s"));

Re: Extract hours to the nearest hours from duration ( hour:min) format

sweetycha — Sun, 28 Jun 2020 19:50:52 GMT

Thank you

Is there a way to do this without a script? I am not familiar with JMP programming but I run sas programming.

Is not then how to recode this with my actual variable name that is called "hours" and is in duration ( hr:min) formant. I would like to create a col hours1 and extract the hours and do the rounding?

Re: Extract hours to the nearest hours from duration ( hour:min) format

txnelson — Sun, 28 Jun 2020 20:17:49 GMT

Attached is a data table with a time column and a formula column called Rounded that rounds the hours using the formula

Round( :Time / In Hours( 1 ) ) * 3600

Re: Extract hours to the nearest hours from duration ( hour:min) format

sweetycha — Sun, 28 Jun 2020 22:54:17 GMT

Thank you.

How to re format the round into hour only value i.e for 12 hours we want 12 not 12:00:00 to make it numeric value

Re: Extract hours to the nearest hours from duration ( hour:min) format

txnelson — Mon, 29 Jun 2020 02:11:54 GMT

Go to the Column Info for the formula column and select a Format to use. Since there is not a direct format that will just display the Hour component of a time based column, you need to select a "Custom" format. The value you need to specify for the custom format is

Hour( value )

Re: Extract hours to the nearest hours from duration ( hour:min) format

Mark_Bailey — Mon, 29 Jun 2020 12:24:33 GMT

I took a different approach. I abandoned time and directly obtained hours. Here is the resulting table:

Here is the formula that I used.

I attached the modified data table for you.