Totaling work hours

D

denny

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

Henry

Bob - the formula for each day works, but the sum for all hours doesn't. I
need =SUM(C1.C2) to add the hours worked together. When I enter the sum
formula, it gives me zero.
 
H

Henry

Well yes - the formula would give you zero because the values are converted
to text. Try summing column A and then B and use your text formula on the
two sums.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Assigning a value to one cell based on the date in another... And then doing it again 0
Getting a formula to reflect added columns 10
calculate total hours based on dates 5
Revenue for month 0
Looking for a way to Force Successor Task to next workday IF 'x' amount of time left in workday 0
Calculate Total Hours when Overlapping Occurs 0
Timesheet hours format not adding 2
Dividing meters by hours = meters per hour 7

Top