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.

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