That is certainly too much information!
Format Custom as [h]:mm:ss
Or post back with formulas, input values, expected and actual results.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"student" wrote in message ...
| Please Help I am trying to calculate total available time for my job and am
| importing files. When importing to Excel and adding 3 columns, the data in
| the 4 th column is not adding up. h:mm:ss to total h:mm:ss. Also, some of
| the colums are less that one hour ( :15:22).
| Thanks so much for your time.