SUM of Numbers with colons (:) such as Hours & Minutes

  • Thread starter Thread starter CLARKSON PHARMACY
  • Start date Start date
C

CLARKSON PHARMACY

Does anyone know how to get the SUM of a column with numbers formated as
Time (hh:mm) useing the SUM formula to get the total numbers of hours in
that column. For example:
Day-1 10:45
Day-2 11:05
Day-3 09:10
Total 31:00

Help is very appreciated.

Wally
 
Hi Wally

for your formula use
=SUM(B1:B3)*24
and format it as a number (format / cells - number)

Cheers
JulieD
 
If you want to have the answer in time format, just use SUM and format the
result cell as [hh]:mm which will cater for more than 24 hours.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Back
Top