Excel formula help

  Clapton is God 14:32 26 Sep 08
Locked

I have an Excel spreadsheet with a column of hours/minutes (for example 18:00, 3:00, 6:00, etc).

However when I try to total those hours/minutes using =SUM(.......) it treats the hours as a 24-hour clock and calculates the sum of the column as a time.

What formula do I need to simply add up the column to arrive at a total number of hours and minutes?

  ZZ Top 14:39 26 Sep 08

I have a similar spreadsheet which works fine. Ensure that all cells, including the cell where the total is, are formatted the same, i.e. custom time: hh:mm. Your formula above is correct, just make sure you display the range of cells correctly e.g. =SUM(D7:D57)

  VoG II 14:40 26 Sep 08

You need to set a Custom format for the result cell

[h]:mm

  Clapton is God 14:42 26 Sep 08

Thanks for your quick response.

Unfortunately that's exactly how I already have the cells formatted, so my problem isn't solved!

  Clapton is God 14:45 26 Sep 08

I was hoping you'd be around!

Problem solved. Thanks a lot.

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

Surface Pro 5 News - release date, UK price, features, specs

Animator Emanuele Kabu’s psychedelic video is a stunning tribute to Lisbon city

Best Mac antivirus 2017