How do I make a timesheet add-up 2 shifts a day over 2 weeks?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm a bus driver. I want to keep track of my hours, and minutes for my own
records, in Excel. Here is an example...

Monday; 5:55am - 9:00am & 2:33pm - 5:33pm = 3hrs, 5min. + 3hrs, 0min. =
6hrs,5min.
Tuesday; 6:00am - 9:00am & 2:33pm - 5:33pm = 3hrs, 5min. + 3hrs, 0min. =
6hrs,0min.

So for those 2 days, so far I'd have 12hrs, 5minutes, times $11.00 an hr. =
(about $132)

My main idea is to even add up the minutes everyday, because they add up to
dollars at the end of 2 weeks. I need to know how to add together 2 shifts
everyday over a 2 week period, using hours, and minutes.

How do I do that?

I'm using MS Office, Excel 2003 (11.5612.5606)
Part of Microsoft Office Professional Edition 2003
On Windows XP Pro OS.

Thanks
Bruce
 
Bruce

Send my an email with "timesheet" in the subject line and I will shoot you
one that might work for you.

Mike060349atxxxaol.com. (Fix the at [@] and remove the xxx)

Mike Rogers
 
Bruce,

Time is held in Excel as a fraction of a day, so it is a number, so you can
easily add it.

I would put the days, Monday, Tuesday, etc., down the rows in column A, and
the start and end times in columns B, C, D and E.

Then in F, use a formula of

=IF(AND(B2<>"",C2<>""),C2-B2,0)+IF(AND(D2<>"",E2<>""),E2-D2,0)

If you put the rate in G, you can then calcualte the daily pay in H with

=ROUND(F2*G2,2)

In the third row, you could get a running total of pay in say H of

=SUM($H$2:H3)

To sum the total hours, just use SUM, but format that cell as [h]:mm


--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)
 
Back
Top