Excel formatting of hours:minutes

  Halmer 07:19 25 Apr 10
Locked

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.

Thanks

  VoG II 08:25 25 Apr 10

You can just add them up:

=A1+B1

and format the result cell as Custom

[h]:mm

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

  Halmer 11:19 25 Apr 10

VoG

  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;
8:00
+
8:00
+
9:00

= 1:00 (ie 1:00AM)

Using the [] brackets you get 25:00

Hope that helps.

Regards,

Simsy

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