Time Clock – Adding Hours

Viewing 1 reply thread
  • Author
    Posts
  • September 16, 2017 at 10:26 PM #24640

    Eddzo
    Participant

    I’m trying to make a time clock for work.
    How can I format the “Hours Worked” Calculation that would up the hours I’ve worked for that day, then using that number to multiply by the hourly rate to determine Pay Check for the day?

    I created these fields:
    Start Time: (Used “Time (hrs, mins) under the Number format)
    End Time: (Used “Time (hrs, mins) under the Number format)
    Hours Worked: (Calculation, Should say you worked 8hr,12hrs,17hrs… Basically the math to add the hours)

    Hourly Rate: ($ dollar amount)
    Pay Check: (Hours Worked x Hourly Rate)

    September 17, 2017 at 1:43 AM #24643

    Brendan
    Keymaster

    Hi Eddzo,

    The Time (hrs, mins) feature under Number Format is for recording durations, not for recording start and end times.

    You should switch those fields to be Time fields directly.

    Then create a Calculation field that subtracts the End Time from the Start Time and gives you the number of seconds between those two times. Then it’s just a bit of math to covert seconds to hours.

    (End Time - Start Time) / 60 / 60

    You can apply the Number Format to that and have it return the Time (hrs, mins) value if you want.

Viewing 1 reply thread

You must be logged in to reply to this topic.