EXCEL formatting (Time=hours & minutes)

  Furkin 18:31 29 Oct 2007
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 2007

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

[h]:mm

  Furkin 18:47 29 Oct 2007

VoG to the rescue once again !

many thanks mate

All done

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

Elsewhere on IDG sites

Alienware 17 R4 2017 review

These brilliant Lego posters show just what children's imaginations are capable of

Mac power user tips and hidden tricks

Comment réinitialiser votre PC, ordinateur portable ou tablette Windows ?