Discover what data silos are costing your org in our commissioned Forrester study. Learn more

Calculating hours worked?

722 1
Showing results for 
Search instead for 
Did you mean: 

I have a tutoring schedule log and I want to calculate the hours I work. Right now, I have a start time and end time, how can I calculate the hours in-between?

1 Reply 1

You can use DATETIME_DIFF() for that:

DATETIME_DIFF({Start}, {End}, 'hours')

You may want to output minutes instead of hours if hours rounds too aggressively for you:

DATETIME_DIFF({Start}, {End}, 'minutes')

And then if you want to manipulate that output into Hours with a decimal you could probably do that in another formula field.