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
You can just add them up:=A1+B1and format the result cell as Custom[h]:mmto ensure that durations of 24 hours or more display correctly.
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:00Hope that helps.Regards,Simsy
This thread is now locked and can not be replied to.
Galaxy Note 8 vs iPhone X
Awful clip art from 1994 is being tweeted every hour by a bot
iPhone X vs Samsung Galaxy Note 8
Les meilleurs navigateurs internet 2017
© Copyright 2017 IDG UK. All Rights Reserved.