Sign Up ›

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
JoyfulGraceJoyfulGrace 

Error: Field Actual_Stop_Time__c may not be used in this type of formula

Hi,
I have a custom object with two custom fields. 
Both fields are DateTime. They are: Actual_Stop_Time__c and
Actual_Start_Time__c

I want to populate another field with the time in minutes between these two fields. I have tried a text field and a number field with a formula. (Actual_Stop_Time__c - Actual_Start_Time__c)*24*60

I am receiving this error: Error: Field Actual_Stop_Time__c may not be used in this type of formula

What am I missing? Thanks!
 
SUCHARITA MONDALSUCHARITA MONDAL

Hi Joy,
Please check with the following link:

https://success.salesforce.com/answers?id=90630000000gvhiAAA

Thanks,
Sucharita
JoyfulGraceJoyfulGrace
Thank you, 

I tried this but I am still getting the same error stating the field
cannot be used in the formula. I am stumped.
SarvaniSarvani
Hi,

The below formula worked fine for me. Try creating a new formula field or changing the existing formula field with return type as text and paste the below formula to count number of hours. 
text(
(floor((Actual_Stop_Time__c - Actual_Start_Time__c)*24))
+
(((((Actual_Stop_Time__c - Actual_Start_Time__c)*24)-floor((Actual_Stop_Time__c - Actual_Start_Time__c)*24))*60)/100)
)

Hope this helps! Thanks