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

[Bruce]

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

 

[Mike Rogers]

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

 

[Bob Phillips]

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)