I created a formula field to show the end time of a volunteer shift on the Volunteer Hours object (formula is below). It seems to be working okay, except that it is only calculating whole hours, when many of our shifts are listed as a duration of, say, 5.5 hours or 4.25 hours. It seems to be rounding up for anything above .5 and rounding down otherwise. Any idea how to make this formula work properly?
TIMEVALUE(GW_Volunteers__Shift_Start_Date_Time__c) + GW_Volunteers__Hours_Worked__c
6 respuestas
Would you mind sharing the field? Its exactly what I need - an end time field. thank you!!
