topic Re: Question about variable with hours in Discussions

Question about variable with hours

Rozenzwaige2 — Sat, 10 Jun 2023 23:39:12 GMT

I have an end-of-work variable of the respondents. I want to set so that people who finish their workday at midnight or 3 AM will be considered as those who finish later, at the moment it presents me as someone who finishes their workday earlier.
How can I set this up?

The problematic observations are highlighted in the attached image:

Re: Question about variable with hours

Thierry_S — Mon, 25 Oct 2021 14:34:26 GMT

Hi,

You will need to include the date (at least the day) in your timestamp; otherwise, JMP will not be able to figure out that the 3:00 AM is on the following day.

Best,

Re: Question about variable with hours

Rozenzwaige2 — Mon, 25 Oct 2021 15:56:34 GMT

The problem is that this is an hour without a date, the end hours of the work represent the hours that the respondents usually finish their workday, it is not an hour of any specific day. There is no way to define the beginning and end of the day?

(E.g. the day starts at 5:00 AM and ends at 4:59 AM)

Re: Question about variable with hours

Craige_Hales — Mon, 25 Oct 2021 16:03:59 GMT

Maybe add inhours(24) to any value < 8AM. You could do that in a formula column. I think you'll be trading one problem for another; the new axis will start at 8 hours and run to 32 hours.

Re: Question about variable with hours

dale_lehman — Mon, 25 Oct 2021 16:29:43 GMT

You can use the Date Difference function (a TimeDate function) even without a date. I tried it with hourly data formatted the way you have it, and Date Difference does work correctly. Just decide what hour you want to measure the differences from and enter that as one of the times to measure the differences relative to.

Re: Question about variable with hours

Rozenzwaige2 — Mon, 25 Oct 2021 16:39:57 GMT

I'm quite an amateur at JMP I would very much appreciate it if you could explain in more detail how to do it

Re: Question about variable with hours

dale_lehman — Mon, 25 Oct 2021 22:53:20 GMT

I have attached a data table with a column formula that measures 24 hourly periods starting at 5AM and ending at 4:59AM.