Trying to add up hours in Excel 2

[comboy]

Hi can someone please let me know what I'm doing wrong, I'm trying to total a column of hours using autosum but am getting wrong answers each time.

my sheets looks like this

Start Finish Hours

07:00 12:30 05:30
06:30 20:00 13:30
05:45 20:30 14:45
08:00 17:30 09:30
09:00 17:00 08:00

Total: 21:45

The Start, Finish & Hours are formatted as HH:MM (Have tested with ISTEXT()& get FALSE)
The hours data is generated by subtracting the corresponding two rows eg L8-K8

The Total row is generated using Autosum & currently set to HH:MM also as when I set it to Number I get 1.31 but as you can see 21:45 is not the total number of hours either it should be 51hrs 15mins.

Could it be that I have the total row formatted as HH:MM and if so what format should I use to get the correct answer?

Thanks in advance for your help,

Graham

 

[xlbo]

change the format of the result to: [hh]:mm

the [] allows times to be shown > than their natural maximum i.e. 24 hours in a day. 51 hours is actually 2 days & 3 hours. If you format as dd hh:mm you would get a result of 2 03:15. The [] allows hours to go > 24, minutes & sec0nds to go > 60 .

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[comboy]

Hi Geoff,

Thanks for that it works a treat.


Graham.

 

[coachdan]

That helped me too.

coachdan32

http://www.malehsbaseball.com