louww
02-19-2014, 12:30 PM
Please help!
I'm calculating time cells (hh:mm) and the sum is more than 24 hours.
All the result cells are formatted as [hh]:mm and the reference cells are all formatted as hh:mm
The sum formula for all time cells works fine, except for one sum cell, which gives a result of fraction time e.g.56655.4444
No matter what I do this one cell's sum formula is not working, even though the reference cells are formatted correctly and are numbers isnumber().
Any ideas?
I'm calculating time cells (hh:mm) and the sum is more than 24 hours.
All the result cells are formatted as [hh]:mm and the reference cells are all formatted as hh:mm
The sum formula for all time cells works fine, except for one sum cell, which gives a result of fraction time e.g.56655.4444
No matter what I do this one cell's sum formula is not working, even though the reference cells are formatted correctly and are numbers isnumber().
Any ideas?