Time Clock – Adding Hours

[Eddzo]

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)

[Brendan]

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.

[Author]

Posts