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?
Page 1 / 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.
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.