Time Data Conversion
On Tuesday, October 2, 2012 12:36:30 PM UTC-4, (unknown) wrote:
Hello. My time data is presented like this: 093004000 093005000 Which is hh:mm:ss.millisec I would like to convert the data so that when I add or subtract the 2 values I get the actual time difference in hh:mm:ss. In the example above, if I did (093005000 - 093005000) the result would be 00:00:01. Thanks in advance.
Thanks. I think that worked. I found that when I took my data from the database and pasted into excel the time formating changed on me.
If the data pastes into excel like this:
Time1 Time2 Diff
93003000 93010000 00:00:07
103040000 113040000 01:00:00
Is there a way to get the result in the 'Diff' column ?
|