Excel formatting of hours:minutes

  Halmer 07:19 25 Apr 10

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 10

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 10


  Simsy 09:58 27 Apr 10

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.

Surface Pro (2017) vs Surface Pro 4

20 groundbreaking 3D animation techniques

How to mine Bitcoin on Mac