DOS Data in Excel Format with Date and Military Time in same cell

[Jules]

I have a worksheet that was imported from a DOS program. The cell with the
time in it has a date stamp I do not want, it's not visable in the DOS
program or the import process...how do I remove it?

I also need to total the amount of time that is left...how do I do that?
When I try to total it at this point it gives me 16 hours....when that is not
possible...I should have well over 4000 hours of time.

Any help would be great!

Thanks,

 

[Ron Rosenfeld]

I have a worksheet that was imported from a DOS program. The cell with the
time in it has a date stamp I do not want, it's not visable in the DOS
program or the import process...how do I remove it?

I also need to total the amount of time that is left...how do I do that?
When I try to total it at this point it gives me 16 hours....when that is not
possible...I should have well over 4000 hours of time.

Any help would be great!

Thanks,

What do you mean by "date stamp"?

Excel stores dates and times as days (since 1/1/1900 or 1/1/1904) and fractions
of a day.

So, using the 1900 date system, if you enter 6 AM into a cell, Excel will store
that as 0.25 and think it represents 12/31/1899 (actually if you format it will
look like 1/0/1900).

If you sum a bunch of times, they will merely add up. So if you had, for
example 100 entries of 6 hours, Excel would compute that the same as 100 *
6/24 = 25. But since you want to "see" your answer in hours and minutes, you
can either format the result as [h]:mm or multiply the result by 25.

The brackets [] around the h tell it to not "roll over" every 24 hours. That's
probably why you are seeing a 16 instead of the 4000+.

One caveat that probably will not apply: The largest single time number you
can enter is 10,000-1. I think the largest time number that can be displayed
(i.e. by summing a bunch of times) is 10,000,000-1


--ron