LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 38
Default Totaling work hours

In column A I have the start date & time; in column B I have the end date &
time; in column C: =TEXT(B1-A1,"h") to deliver the hours worked on a given
day. At the bottom of column C, I want to have the total of hours worked over
a period of time. I've tried nesting formulars. However, it returns with a
too many or too few arguments or a #VALUE! error. I'm obviously doing
something wrong. Can anyone show me how it's done?
 
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
Totaling some hours but not others HELP! vanilla_bean_orange via OfficeKB.com Excel Worksheet Functions 8 February 16th 06 10:01 AM
Keeping track of and totaling hours worked Popeye Excel Discussion (Misc queries) 2 January 14th 06 02:21 AM
Totaling Hours in Standard Format Coco Excel Worksheet Functions 4 July 30th 05 12:31 AM
totaling times past 24 hours txduster Excel Worksheet Functions 2 February 21st 05 04:39 PM
in excel totaling weekly hours military time mel Excel Worksheet Functions 1 January 17th 05 04:24 PM


All times are GMT +1. The time now is 07:05 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"