LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.newusers
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Make rulers available in excel! MikeLinPA Excel Discussion (Misc queries) 2 December 28th 05 10:18 PM
Can I make formulas more flexible? George Excel Discussion (Misc queries) 3 November 8th 05 05:38 PM
How do I make each row add up seperatly? Please make it easy... Homeade baker and candy maker New Users to Excel 1 October 23rd 05 09:52 PM
make a cell empty based on condition mpierre Charts and Charting in Excel 2 December 29th 04 01:01 PM
How to make this plot? springwinterfall Charts and Charting in Excel 2 December 22nd 04 07:35 PM


All times are GMT +1. The time now is 05:24 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"