You need to sign in to do that
Don't have an account?
kishore eppa
How to calculate time difference(data type "Time")
Hi All,
I have 3 fields like below
Start time and end time both data type “Time”, Total Spent data type is “Number”.
Start_Time__c = 2:10
End_Time__c = 3:20
Total_Spent_Time__c= 1:10 OR 70
How to calculate time difference or How to convert a number to time ..?
I have 3 fields like below
Start time and end time both data type “Time”, Total Spent data type is “Number”.
Start_Time__c = 2:10
End_Time__c = 3:20
Total_Spent_Time__c= 1:10 OR 70
How to calculate time difference or How to convert a number to time ..?
You can make Total Spent field as a Formual field . Formula will be (End_Time__c - Start_time__c) / (60*1000)
Thanks,
already i tried same thing but i'm getting below error
Error: Formula result is data type (Number), incompatible with expected data type (Time).
.