View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Niek Otten Niek Otten is offline
external usenet poster
 
Posts: 3,440
Default time columns not adding correctly

<That is certainly too much information!

Not

"Niek Otten" wrote in message ...
|
| 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.
|
|