How Do I Figure Out The Formula For Figuring Time Cards?


4 Answers

Thomas Rooney Profile
Thomas Rooney answered
Firstly ensure that all cells are formatted correctly to ensure they will add up the lines/ columns correctly. For example, ensure that where you enter your clocking in and out times, the cells are formatted as time. Most time cards set out in EXCEL will have three main rows; top row for total hours; middle row for regular hours and bottom row for overtime hours.

If the cell for Total hours, Monday is cell B1, then:
The formula in cell B2 "Regular Hours" is:
the formula in cell B3 "Overtime hours" is:

You simply fill the Total hours in cell B1, and the Regular Hours (cell B2) and Overtime Hours (cell B3) will be automatically calculated and filled.

While most of us have seen and may even have used Excel spreadsheets, few really understand the power of excel formulas. Excel Formulas is one of the backbones of the highly versatile program, offering the user the limitless ability to perform complex calculations while tracking data.

There are many different uses for Excel, from making invoices to tracking employee hours (which is what this question mentioned) and figuring out deductions. While many people understand how excel formulas work few people know how to make them work, which is where the real power and flexibility of this program lies. If you have ever had to crunch numbers for your business, as an employer or even when trying to create and stick to a budget at home you know how handy a custom spreadsheet can be for these tasks.

This almost limitless nature of Excel makes it very difficult to get a full grasp of. Each function requires knowledge of a certain formula in order to work out the required sums. There are, however, many books that can be purchased giving detailed examples of the different functions of Excel with examples of formula; such information can also be found on Excel related online forums.
Oddman Profile
Oddman answered
The answer to this question may be helpful. You subtract the start time from the end time and then subtract the length of any unpaid breaks. It helps to convert all times to hours. To do that, divide minutes by 60 and add to the hours:
1:42 p.m. = 1+42/60 after 12 noon = 12 + 1 42/60 = 12 + 1.7 = 13.7 hours.

(time worked) = (end time) - (start time) - (length of unpaid breaks)

If the end time is on a different day than the start time, add 24 hours for each day: 11 p.m. To 4 a.m. = (24 + 4) - (12 + 11) = 28 - 23 = 5 hours.

Anonymous Profile
Anonymous answered
Anonymous Profile
Anonymous answered
If I have 71.60 hours on my time worked, how many hours/minutes would I need to stay or leave to get exactly 80 hours.

Answer Question