how to I set up the following duration formula?
I am trying to calculate the number of volunteer hours from a start date and end date of an event. How do I set up the formula?
Forum Discussion
I suggest that you have two time of day fields types for input.
Then ToHours([end time]-[start time])
You may also want to do
if(not IsNull([end time]) and not IsNull([Start Time]),ToHours([end time]-[start time]),0)
Then ToHours([end time]-[start time])
You may also want to do
if(not IsNull([end time]) and not IsNull([Start Time]),ToHours([end time]-[start time]),0)