Duration as difference betweed to Datetime fields does not respect Seconds

Question

It seems that Seconds are ignored in formula fields if you create the difference between Datetime/Time fields.

Say you have two Datetime fields: End__c and Start__c

Take a formula field Duration__c (in Seconds) defined as

(End__c - Start__c) * 24 * 60 * 60

Assume

Duration__c evaluates to 0.00 seconds but should be 2.00 seconds

It's also a challenge to enter seconds on the standard UI. See therefore salesforce.stackexchange.com/questions/48299/… — Uwe Heim, Commented Sep 2, 2014 at 10:16

Uwe Heim · Accepted Answer · 2014-09-02 15:54:45Z

2

You can modify the formula to include Seconds into the evaluation

  ( End__c - Start__c ) * 24 * 60 * 60
+ ( VALUE(MID(TEXT(End__c),18,2)) - VALUE(MID(TEXT(Start__c),18,2)) )

answered Sep 2, 2014 at 9:26

Uwe Heim

28.5k20 gold badges121 silver badges287 bronze badges

1

Uwe - you might want to mark this as 'solved'
– cropredy
Commented Nov 8, 2014 at 2:37

Add a comment |

1 Answer 1