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" wrote:

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