Adding Hours and minutes

  • Thread starter Thread starter Dargo
  • Start date Start date
D

Dargo

I have a column of fig's showing the hours and minutes that my vehicle
have been "off the run" awaiting repairs. Could anyone tell me how t
total these to give a total time in hours and minutes. I have trie
=SUM(F5,F6) and =SUM(F5,F6)*24 but it returns O. Any help would b
appreciated

Ala
 
Hi Dargo!

All of your data on hours and minutes should be times. Check that they
are not text. Use ISNUMBER(A1) which should return TRUE.

Also if the times exceed 24 hours, format the cell [hh]:mm:ss

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
If SUM(F5,F6) doesn't work, that would suggest that the values that you have
are text not time.

To check, put this formula in a cell, =ISTEXT(F5). If it says true, then
you have text.

If you have a lot of such values, one way to fix them is
- put a 1 in a cell and copy this to the clipboard
- select the 'time' cells
- goto Edit>PasteSpecial
- in the Operation section, click the Multiply option
- OK
- now re-format to time

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Back
Top