time columns not adding correctly

[student]

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.

 

[Niek Otten]

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

| 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.

 

[Niek Otten]

<That is certainly too much information!>

Not

|
| 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
|
|| 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.
|
|