View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips[_3_] Bob Phillips[_3_] is offline
external usenet poster
 
Posts: 2,420
Default Totaling work hours

Use the formula

=--TEXT(B1-A1,"h")

this will SUM normally then

--
__________________________________
HTH

Bob

"denny" wrote in message
...
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?