Skip to main content

Calculating hours worked?

  • February 18, 2020
  • 1 reply
  • 17 views
E

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

    J
    Forum|alt.badge.img+18

    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.

    Terms & ConditionsAccessibility statement