Need help using Excel to make a timesheet.?

Question

what formula would I use to get it to calculate time?

Answer 1

If A1 has the starting date & time (ie, 1/9/07 11:00 AM) and A2 has the ending date & time (ie, 1/10/07 10:37 AM) then this formula:
=24*(A2-A1)
produces this result:
23.6197
if the cell with the formula is formatted to be a number. If Date and time are in separate cells, you can add them together: A1 = B1 + C1 where B1 is the date and C1 is the time.

No need for military time or any other calculations!

Answer 2

To make it easier on yourself, use a 24-hour clock (i.e., military time) and round up to the nearest 15 minutes (federal law will let you do this - check out Title 29, US Code of Federal Regulations, Part 516). Put the time you start in cell A-1, then the time you leave for lunch in A-2, then when you come back is A-3, and when you leave for the day into A-4. Then, A-5 should be "Sum(A4-A3)+(A2-A1)." That should do it for the day.

Then, copy this formula into B-1 through B-5, etc., all the way through G, so that you have one column for each day of the week. Into cell H-5, put the formula "sum (A5:G5)" and that should give you a weekly total. Repeat for however many weeks you need.

Hope this helps.

Answer 3

I have two versions of this already done. My wife works in payroll and needed a way of converting manual time cards into hours worked for their payroll system. I will send them to you if you send me your email address.

Please reference "Timesheet Calc.xls" in your message. I will send you both versions.

Hope this helps.

Kind Regards,
QwertyKPH @ Yahoo

Answer 4

The following questionnaire will help you determine whether you need Project Insight Enterprise, Workgroup Edition, or a Workgroup Professional Edition.