Time Data Conversion

  • Thread starter Thread starter cmiedaner
  • Start date Start date
C

cmiedaner

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.
 
Hi,

Am Tue, 2 Oct 2012 09:36:29 -0700 (PDT) schrieb (e-mail address removed):
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.
Click to expand...

try:
=(A2-A1)/86400000
and format the cell hh:mm:ss


Regards
Claus Busch
 
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.
Click to expand...

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 ?
 
Hi,

Am Tue, 2 Oct 2012 10:38:05 -0700 (PDT) schrieb (e-mail address removed):
Time1 Time2 Diff
93003000 93010000 00:00:07
103040000 113040000 01:00:00
Click to expand...

try:
=(TEXT(B1/1000,"0\:00\:00"))-(TEXT(A1/1000,"0\:00\:00"))


Regards
Claus Busch
 
Back
Top