You need to sign in to do that
Don't have an account?
Keith Shapiro
Date/Time field subtraction.
I've found some things here but not something I can get to work.
2 fields Join_Time__c, Leave_Time__c I want to produce a number in minutes by subtracting the time they joined from the time they left a webinar either 42(NN) or HH:MM will be acceptable. I need to know the field type to use and the formula. I'm not finding what I'm looking for that will work for some reason.
Thanks!
2 fields Join_Time__c, Leave_Time__c I want to produce a number in minutes by subtracting the time they joined from the time they left a webinar either 42(NN) or HH:MM will be acceptable. I need to know the field type to use and the formula. I'm not finding what I'm looking for that will work for some reason.
Thanks!
Create both of the those fields as Date/Time fields. (I called mine End__c and Start__c)
Now, create an additional formula custom field, I called mine "Difference". This field should return a text type.
The body of the formula will be:
This will return the number of minutes between End and Start...
All Answers
Create both of the those fields as Date/Time fields. (I called mine End__c and Start__c)
Now, create an additional formula custom field, I called mine "Difference". This field should return a text type.
The body of the formula will be:
This will return the number of minutes between End and Start...
(Leave_Time__c - Join_Time__c)*1440
Many thanks!