swaink
Active Member
- Joined
- Feb 15, 2002
- Messages
- 432
Hi All
I have browsed for the answer to this one and found a few answers that point me in the right direction but they don't quite fit what I need.
I need to convert the data from a text value to HH:MM
I have been given an extract of some 40k lines in one column I have the time of an event showing as 0.013 instead of 00:13 another may be 0.125 which would be 01:25.
Would anyone be able to offer any suggestions as to how I can best convert these values
Regards
Kevin
I have browsed for the answer to this one and found a few answers that point me in the right direction but they don't quite fit what I need.
I need to convert the data from a text value to HH:MM
I have been given an extract of some 40k lines in one column I have the time of an event showing as 0.013 instead of 00:13 another may be 0.125 which would be 01:25.
Would anyone be able to offer any suggestions as to how I can best convert these values
Regards
Kevin