326332_en-US

liliconcom

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

The formula is pretty straight forward

:Time - :Time[1]

I have attached an example data table

Convert time AM/PM into duration (in minutes)

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 

 

 

 

 

 

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

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

Re: Convert time AM/PM into duration (in minutes)It works ! Thanks a lot