Help

Calculating hours worked?

1556 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Elaine_Winter
4 - Data Explorer
4 - Data Explorer

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.