How Do I Calculate Time Cards?


8 Answers

jerome penn Profile
jerome penn answered
The most simple and easiest way to manually calculate a time card is to first convert the minutes into decimals, for example, 15 minutes is equal to 0.25, 30 minutes is equal to 0.50 and 45 minutes is equal to 0.75.

Now work out the regular hours that you have worked during that week which of course will be paid at your normal regular rate. For example, your time card could end up reading:

In work: 7.15am
Lunch: 11.00am
Back at work: 12.00pm
Leave work: 4.15pm

When you subtract the hour that you took for lunch, this equals to eight hours of work.

The next thing you do is figure out your overtime, if this is applicable. But once you have worked this out, don’t just add it straight onto your regular hours as you should be paid a different rate of pay for any overtime you do, this usually around 1.5 times your regular rate unless your state or company has a different rate of pay.

Once you know how many regular hours your have worked that week and how much overtime you have done, you should be able to gain a rough idea of how much you will be receiving when your pay check arrives.

A couple of tips to make the whole process easier is to convert to military time if possible. For example, 1pm in the afternoon because 1300; 2pm is 1400, 3pm is 1500, and so on. Another tip is to round the minutes to the nearest five minutes, for example, round 13 minutes up to 15 minutes or 26 minutes down to 25 minutes.
Anonymous Profile
Anonymous answered
Don't be silly. 7:56 a.m. Clock-in and 5:23 p.m. Clock out is nominally an 8-5 shift which is a standard 8-hour shift with an unpaid 1-hour lunch. So just count the hours first and deal with the minutes separately. So, you have 8 full hours total. Then you have 4 minutes before the shift and 23 minutes after the shift for 27 extra minutes. Voila! 8hrs and 27 minutes.
Anonymous Profile
Anonymous answered
Total hours= sum of daily hours
Anonymous Profile
Anonymous answered

But none of the above take into account a given employer's system for
rounding time-clock entries.  Many employers round to the nearest
quarter hour.  Some to the nearest tenth of an hour, and some to the
nearest five minutes. 

All of these schemes are legal (depending on
local and federal law) as long as the scheme works "both ways". I.e. Can
work to the advantage or disadvantage of the employee, and therefore
theoretically averages out so that neither the employee or employer is
being treated unfairly.

Of course, employees quickly figure out
"the game" and, in the case of quarter-hour rounding, for example, hurry
to punch in before the clock rolls over to 8 minutes after the hour and
may linger for a few minutes when punching out, hoping to let the clock
roll over to 8 minutes past the hour, half hour, or quarter hour to try
to pick up extra time.

So in any case, when you write a program or spreadsheet to compute paid hours, you have to set
it up to use the same "rounding rule" as the particular employer uses.

Venessa Perez Profile
Venessa Perez answered

The easiest way is using a tool to calculate time. There's daily and weekly online tools like this timecard calculator that let you add hours in, hours out, and break time to get the hours worked in decimal. Once the hours worked are in decimal form, simply multiply by hourly rate to get the weekly earnings. 

John  Munos Profile
John Munos answered

Every time card is different, so you really should talk to your manager if you're not sure how to fill out your time card.
At a very basic level, most time cards have a box for every day of the week, and you write down the number of hours you worked for that day. Some time cards have you write down your start time and end time instead of just the total hours - so you'll have to add up the number of hours. Then add up all the hours for the week.
But again, without seeing your time card we can't tell you exactly how to calculate it. Talk to your manager to get help. I suggest you Percentage calculator through this you get more results about How to calculate percentage .

Anonymous Profile
Anonymous answered
When having to figure out time cards manually this is what you do:
For example: In 9:24 Out 1:00 In 1:45 Out 3:00

9:24 to 1 needs to be rounded to the next hour so you take 9:24 and make it 10:00
10:00 to 1= 3 hours
60mns - 24mns = 36mns/60mns=0.60     So for the AM you worked 3 hours plus .60 (3.60)

1:45 to 3 needs to be rounded to the next hour so you take 1:45 and make it 2:00
2:00 to 3:00 = 1 hour
60mns - 45mns= 15mns/60mns=0.25      So for the PM you worked 1 hour plus .25 (1.25)

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:
- 7.967
4.083 hours

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

Answer Question