I have a text file with records like this.
The data came from Backup Exec catalogs.
I know (I think) how to convert the BackupTimeUTC field. Getting the dd/mm/yyyy is good enough for me. This seems to do it. I'm using excel to convert:
Which shows as it should: 5/5/2009 7:09:08 PM
What I need to know is...
- How to convert the other fields, BackupDate and BackupTime? Those fields don't seem to indicate they are the same type as the BackupTimeUTC. If they were, wouldn't they just be concatenated, resulting in the same value? Anyway, what's the correct excel formula to convert them?
Or, maybe they are unrelated to BackupTimeUTC and are suppose to result in different values?