Convert time AM/PM into duration (in minutes)

[#1]

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 

 

[#2 · Accepted solution]

The formula is pretty straight forward

:Time - :Time[1]

I have attached an example data table

[#3]

It works ! Thanks a lot

[#4]

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

[#5]

@ 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.

[#6]

Sorry, I misread your request :)