Excel formula help

  Clapton is God 14:32 26 Sep 2008

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 2008

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 2008

You need to set a Custom format for the result cell


  Clapton is God 14:42 26 Sep 2008

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 2008

I was hoping you'd be around!

Problem solved. Thanks a lot.

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

Elsewhere on IDG sites

The Evil Within 2 review-in-progress

InVision Studio takes on Adobe XD and Sketch

Camera tips to take better iPhone photos

Comment transformer un iPhone en borne Wi-Fi ?