summing up hours spent on jobs

K

kayti57

I am trying to track time spent on jobs and I have my hours totaled using the
following format: =TEXT(D5-C5,"h:mm")

However, Now I want to total all these numbers and cannot figure out the
format to do that.

Any ideas?
 
D

Dave O

So it sounds like the start time is in col C, the end time in D, and
the elapsed time in another column, maybe E. In your elapsed time
formula you're using the TEXT function, which performs the math but
then converts the result to a text entry for formatting. That's why
you don't see results when you try to sum the elapsed time: it's all
letters.

As a workaround, you can sum the end times in column D, sum the start
times in C, subtract C from D to get elapsed time, and apply the TEXT
function again, perhaps something like this:
=TEXT(SUM(D5:D21)-SUM(C5:C21),"h:mm")

Will that do the trick?
 
T

T. Valko

=TEXT(D5-C5,"h:mm")

That formula is returning a TEXT string. You should use this formula:

=D5-C5

And format the cell as h:mm

Then, to get the total from a range:

=SUM(.........)

And format that cell as [h]:mm

Biff
 
Top