I'm sorry, my brain is fried today. could anyone look at this sheet and tell me how to get the correct hours into M14 for the hours that were worked that week. Need help with the formula...
I really appreciate it.
Results 1 to 3 of 3
Thread: Time sheet woes
-
5 Star Lounger
- Join Date
- Jan 2001
- Location
- Jacksonville,NC, USA
- Posts
- 705
- Thanks
- 0
- Thanked 0 Times in 0 Posts
2010-01-29 10:51NMP <img src=/S/cool.gif border=0 alt=cool width=15 height=15>
If you can't convince them, confuse them. - Harry Truman <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29>
-
Subscribe to get a FREE chapter from Windows 7 The Missing Manual
This month, every Windows Secrets subscriber can download a one-chapter excerpt of Windows 7: The Missing Manual.Windows 7: The Missing Manual provides valuable information to help you overcome these difficulties in learning a new operating system. Subscribe today to download your free excerpt.
-
3 Star Lounger
- Join Date
- Nov 2005
- Location
- Asia Pacific, Bangkok Metropolis
- Posts
- 378
- Thanks
- 0
- Thanked 0 Times in 0 Posts
2010-01-29 11:44Hi
Does the attached do what you want?
Format the cell M14 by right click
choose Format Cells >>select Custom and choose [h]:mm:ss
HTHHope this is helpful
francis, <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>
My Reading
Pivot Table 101
Pivot Table
Array
-
5 Star Lounger
- Join Date
- Jan 2001
- Location
- Jacksonville,NC, USA
- Posts
- 705
- Thanks
- 0
- Thanked 0 Times in 0 Posts
2010-01-29 12:29HTH,
Thank you. That was it. You saved my fried brain from exploding.NMP <img src=/S/cool.gif border=0 alt=cool width=15 height=15>
If you can't convince them, confuse them. - Harry Truman <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29>
