Apex Code Development You need to sign in to do that
Don't have an account?
Adeline Moore Need Formula Help Please:)
I created a time clock app very basic 5 required fields:
Here are my questions:
1. I would like a formula to calculate the hours volunteered that day
2. I would like to add a "Submit" button (Most will be accessing this on salesforce 1 mobile)
3. I would also like to add actions at the end
a. Update a Volunteer hours Campaign
b. Update the Members contact record with their hours
Here are my questions:
1. I would like a formula to calculate the hours volunteered that day
2. I would like to add a "Submit" button (Most will be accessing this on salesforce 1 mobile)
3. I would also like to add actions at the end
a. Update a Volunteer hours Campaign
b. Update the Members contact record with their hours
Change In-Time and Out-Time fields to data/time format and use below formula. It will work perfectly
(FLOOR(( Out_Time__c - In_Time__c )*24))
+
ROUND((((
((Out_Time__c - In_Time__c )*24)-
FLOOR((Out_Time__c - In_Time__c )*24))
*60)/100),2)
Result :
All Answers
Please help
Kindly mark it as an answer if that works !
Change In-Time and Out-Time fields to data/time format and use below formula. It will work perfectly
(FLOOR(( Out_Time__c - In_Time__c )*24))
+
ROUND((((
((Out_Time__c - In_Time__c )*24)-
FLOOR((Out_Time__c - In_Time__c )*24))
*60)/100),2)
Result :
This worked Perfectly just had to switch the order of In Time to Time In etc. Thank you very much!