Skip to main content The new Salesforce certifications experience is live! Visit Trailhead Academy to explore your new certifications homepage.
Topics#Data ManagementCharmaine Rhule's Question
Charmaine Rhule (Battersea Dogs and Cats Home) asked in #Data Management
Jan 29, 2018, 10:17 PM

TimeValue formula field - How to calculate total time between two time values

My formula: I am using the HH:MM Beta field and want to know the total time ( Hours:mm ) between to other time values only.   No Date/Time is required.

 

Formula:

 

TIMEVALUE( (Clock_Out__c)TIMEVALUE (Clock_In__c)))

 

My error:  Error: Syntax error. Missing ')'

 

 
1 answer
  1. Gavin Dimaria
    Jan 29, 2018, 10:38 PM
    TIMEVALUE(Clock_Out__c) - TIMEVALUE(Clock_In__c)
Write an answer...
0/9000