View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Bruce Bruce is offline
external usenet poster
 
Posts: 138
Default How do I make a timesheet add-up 2 shifts a day over 2 weeks?

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