Microsoft Office 2007 home and student

I have a cell with a start time and another with and end time. My formula =IF(GD28>GE28,GE28+1-GD28,GE28-GD28)

provides me with the difference.

Start 9:22 pm to end of 9:27 PM result is 0:05 which is what I want. This formula is used to provide durations throughout a day.Now I want to add the results of these formulas. For example the result of 0:05 to 1:05 to give me 1:10. I keep getting #value if I use the sum function....what do I need to do?

In GF1, I put =IF(GD28>GE28,GE28+1-GD28,GE28-GD28)

In GD28, I put 9:22

In GE28, I put 9:27

The result was 0:05In GF2, I put =IF(GD29>GE29,GE29+1-GD29,GE29-GD29)

In GD29, I put 10:45

In GE29, I put 11:50

The result was 1:05In GF3, I put =SUM(GF1:GF2)

The result was 1:10

Hi, Can you confirm that the error you are seeing is the error value: VALUE#!

or is it a row of ######'sSUM() is quite tolerant of non-numeric values and usually only returns #VALUE! if one of the cells in the SUM(range) has an #VALUE! error.

I am assuming that none of the individual time durations is giving an error.

As DerbyDad03's post shows, SUM() works for adding individual times, so the error is not the SUM() function itself.

Excel displays a row of #s if the date/time will not fit in the cell (widen the column), or if the result of the date/time calculation is negative.

Regards

Ask Your Question

Weekly Poll

Would you ride in a self-driving car from Tesla?

Discuss in The Lounge

Poll History