EXCEL formatting (Time=hours & minutes)

  Furkin 18:31 29 Oct 07
Locked

Hi all,
Further to my post of some weks ago, re adding Hours & Minutes in EXCEL.
Thanks to your help, I had it working,,,, or so i thought !
I had the sum of column A of 23:25,,,, but today when I went to add 1:00 (= 24:25) it comes up as 00:25.
It looks as though it adds the hours/minutes, up to 23:59 (hours per day)!
Can I get this to read 24:25 etc etc (plus more as the days go on) ?
I'm currently using "=sum(A1:A45)"

cheers

  VoG II 18:32 29 Oct 07

Your formula is fine but you need to use a custom format in the result cell

[h]:mm

  Furkin 18:47 29 Oct 07

VoG to the rescue once again !

many thanks mate

All done

This thread is now locked and can not be replied to.

Sniper Elite 4 review: Headshotting Nazis has never felt so good

1995-2015: How technology has changed the world in 20 years

The Best Design, Illustration, Animation and VFX Awards of 2017

WWDC 2017 dates: How to get WWDC 2017 tickets, when is WWDC 2017 and more details announced