Adding formulas with times

Microsoft Office 2007 home and student
January 28, 2010 at 12:50:38
Specs: Windows XP
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?

See More: Adding formulas with times

Report •

January 28, 2010 at 13:02:27
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:05

In 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:05

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

Report •

January 29, 2010 at 04:02:25

Can you confirm that the error you are seeing is the error value: VALUE#!
or is it a row of ######'s

SUM() 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.


Report •

Related Solutions

Ask Question