Excel formatting of hours:minutes

  Halmer 07:19 25 Apr 2010

Can someone advise how I list hours and minutes in a worksheet so that I can add them up please i.e. 08:30 plus 07:45 equals 16:15.


  VoG II 08:25 25 Apr 2010

You can just add them up:


and format the result cell as Custom


to ensure that durations of 24 hours or more display correctly.

  Halmer 11:19 25 Apr 2010


  Simsy 09:58 27 Apr 2010

when formatting, by using the [] brackets round the "hours" component, you are formating as a "duration" rather than as a "time"...

There is such a thing as 25 hours duration, but no such time as 25 O'clock...

if formatted without the [] brackets;

= 1:00 (ie 1:00AM)

Using the [] brackets you get 25:00

Hope that helps.



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

Elsewhere on IDG sites

Samsung Galaxy S9 review

Explore Milton Glaser's iconic poster designs from the 1960s to present, including Bob Dylan, I…

What to expect at Apple's 27 March education event

Idées cadeaux pour geeks et tech addicts