Hi all,
I have a string of time stamps in general number format, i.e. 1254, 1257, 1259, 1301, 1304, ...etc.
I want to find the difference (mins) between each one, i.e. from above, 3, 2, 2, 3, ...etc
Problem is that in the general number format is stuffing it up, i.e. 1301 - 1259 = 42, which is not correct.
When I convert the format to time, it just ignores the original time and displays it as 00:00.
How can I turn the original numbers to a format that will make sense when I measure the differences between numbers??
Thanks.
Dave
Bookmarks