 ShowAll Questionssorted byDate Posted Tirat

# Formula to calculate elapsed seconds between events

Hello,

I need to create a formula field to calculate the elapsed number of seconds between 2 Date/Time fields. The formula below:

EndDateTime - StartDateTime

Only returns the number of elapsed days. What is the formula that would return the number of elapsed seconds?

Thanks you. Best Answer chosen by Admin (Salesforce Developers)  sfdcfox

Multiply the differences of your two date/time fields by 84600. The calculation is a fractional number, if memory serves me correctly, so multiplying by the number of seconds in a day will yield the total number of seconds between events. sfdcfox

Multiply the differences of your two date/time fields by 84600. The calculation is a fractional number, if memory serves me correctly, so multiplying by the number of seconds in a day will yield the total number of seconds between events.

This was selected as the best answer Tirat

Thank you very much!

Worked perfectly. Søren Landschultz
Thanks!
I got this to work but should correct the formula to: (DateTime2 - DateTime1) * 86400
...not 84600 as stated in the Best Answer. Mohan Raj 33
@sfdcfox Hi, If I want to provide the time differecne in the two date/time fields in hours what chages I make in  into your code. Mohan Raj 33
@Søren Landschultz Hi, Sir I have same problem as I am also now try to get a two date/time field's difference in the result field is number field in the result is in hour I have a doubt if in that the two date/time fields itself I am using one is NOW() so Please help me to solve this issue.Thank You Mohan Søren Landschultz
@Mohan Raj 33: If you want to calculate the hours elapsed between NOW and another Date/Time field, your formula should be:
(NOW() - DateTimeField)  *  24