Suppose columns A & B have hours listed as whole numbers, columns C & E have
minutes listed as whole numbers, and columns D & F have seconds displayed as
whole numbers.
=TIME(A2+B2,C2+E2,D2+F2)
Format this total cell as [hh]:mm:ss
--
** John C **

"Jennifer" wrote:

I have a file in excel where there are five columns that have time formated
as basic numeric. Example: 30 minutes displays as 30, 10 hours displays as
10. How do I show these 5 columns as hours ?
Second question: I have an additional column where the time is displayed as
minutes (on the same worksheet as the five columns). I placed a formula where
it changes it to hours/minutes (= cell/1440) and then format the cell ([h]:mm.

Now I am trying to sum the 6 columns in the worksheet to get the total hours
and is not working. Any suggestions ?