AnsweredAssumed Answered

How to work out the time lapse (difference) between 2 times.

Question asked by on Jan 4, 2019
Latest reply on Jan 4, 2019 by philmodjunk

Hello Community,


I have an ordering system.


We have order receive date field. This is dropdown calendar field allowing user to select date.

We have Order receive time field. This is free text field. User enter the time order is received. so for example 12:00 AM or 02:45 PM.

I created third 'Calculation' field to put date and time field together. so if user select date is 04/01/2019 and user enter time is 12:45PM; the calculation result would be 04/01/2019 12:45PM.


I have forth field known as 'Order send date'. This is timestamp when user send order; the script will add timestamp in order send date field.


I would like to work out the time difference between the 2 times.


So I have a following calculation formula.


DateTimeField (calculation field which merge date + time) - OrderSendDate.


Time lapse seem to be skipping days lapse. For example first record also has 2 days difference.



How I can fix this please so I have full time lapse include Days::Hours::Minutes.


Thank you