topic Re: Convert time AM/PM into duration (in minutes) in Discussions

Convert time AM/PM into duration (in minutes)

JMPdiscoverer — Sat, 10 Jun 2023 23:21:15 GMT

Dear JMP users,

I need to create a column for time in minutes, which correspond to the duration considering the first Date as the starting point).

Dates were given in h:m:s AM/PM.

Do you know which formula I need to use ?

Thanks

Re: Convert time AM/PM into duration (in minutes)

txnelson — Sun, 25 Oct 2020 10:14:46 GMT

The formula is pretty straight forward

:Time - :Time[1]

I have attached an example data table

Re: Convert time AM/PM into duration (in minutes)

ThuongLe — Mon, 26 Oct 2020 06:15:27 GMT

Or you can use MINUTE() keyword to achieve the same result

Re: Convert time AM/PM into duration (in minutes)

JMPdiscoverer — Mon, 26 Oct 2020 06:28:38 GMT

It works ! Thanks a lot

Re: Convert time AM/PM into duration (in minutes)

JMPdiscoverer — Mon, 26 Oct 2020 06:32:57 GMT

@ ThuongLe , Thanks for your answer, however the Formula "minutes" gives you minutes for each corresponding date without converting number of hours into minutes, and also its does not calculate the duration of time.

Re: Convert time AM/PM into duration (in minutes)

ThuongLe — Mon, 26 Oct 2020 06:46:12 GMT

Sorry, I misread your request :)