Adding Hours & Minutes

[TOWNMAN]

I am trying to sum hours and minutes. I have the cells formated to Time


613 Mr Jozef 29-Jul-05 03:45:00 00:00 00:00
613 Mr Jozef 30-Jul-05 10:25:00 00:00 00:00
613 Mr Jozef 31-Jul-05 11:15:00 00:00 00:00

I am getting an answer of 1.25 when I should get 25.25. If I multiply by 24
as suggested by the excel help I get 10.00.

However I have noticed if I highlight the cells I get the correct answer in the status bar.

Anyone know how to get it working correctly?

Thanks

Townman

 

[ScotB]

Try formatting the cell you are summing in as [h]:mm:ss

 

[TOWNMAN]

Thanks ScotB


That did the trick.



Regards


Townman