ClimoC
Well-known Member
- Joined
- Aug 21, 2009
- Messages
- 584
I know what someone is going to think... "[h]:mm:ss"
That's not the problem.
The finished sheet is a file for importing to third party software. It doesn't handle the "01/01/1900" that is appended to the time when it goes passed 24hrs.
Hundreds of lines of code, do not want to remove them manually.
How can I remove the "01/01/1900" from the cell value?
That's not the problem.
The finished sheet is a file for importing to third party software. It doesn't handle the "01/01/1900" that is appended to the time when it goes passed 24hrs.
Hundreds of lines of code, do not want to remove them manually.
How can I remove the "01/01/1900" from the cell value?