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

Xiaomi Mi Mix 2 review

What went wrong at the Designs of the Year 2017

iPhone X news: Release date, price, new features & specs

Comment regarder des séries et talk-shows américains en France ?