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?
|