DOS Data in Excel Format with Date and Military Time in same cell
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,
--
Jules
|