How Do I Calculate Time Cards?

The easiest way to do this is to convert minutes to fractional hours and then subtract. Use this chart to convert the minutes to hours. Once this is done then the procedure is simple subtraction. Example: Bob clocks in at 7:58, out at 12:03, in at 12:59, and out at 5:15. Convert the minutes to their decimal equivalents using the chart:

7:58 = 7.967
12:03 = 12.050
12:59 = 12.983
5:15 = 5.250

Now subtract the clock-ins from the clock outs:
12.050
- 7.967
--------
4.083 hours

5.250
0.983 (treat 12 as zero for purposes of subtraction)
--------
4.267 hours

Total time: 8.35 hours

If you need an actual formula to convert minutes into a fractional hour, use this:

Faction = minutes / 60

Add Comment

Report