String format to Time format

[GraveHag]

Greetings, I'm new and my question is very simple but I'm not able to find a solution.

I have a string that I extracted from IPCam log in this format: "01:24:02.455". This is the original format. And now, I need to convert this into time format like "hh:mm:ss:ms" for another operations.

Here is my solution:

1) separate ":" and "." I'll get "012402455" it's a number in string format, right? But what to do now? How to convert into Date(time) format 01:24:02:455? I tried something like CDate and so on. But without correction.

I need to find an algorithm that can convert lots of string numbers into Date (time) format for operations that helps me determinate differences between two time.

For example:

I have a data log that says to me: IP cam lost signal in 01:24:02.455 and IP signal was connected in 01:24:03.810. and I need to extract with precision the right time. So my answer will be: the IP cam was disconnected for 00:00:01:355

I am not sure if the right format could be "hh:mm:ss:ms" or "hh:mm:ss.ms"? What is the right format?

Thanks a lot for your help in this very very strange piece...

[Daishiknyte]

The worksheet function Timevalue() should handle that for you. It will convert "01:23:45.678" into 0.0581675694444444 decimal days.

[Pete_UK]

You can just use this formula to convert a string in that format which is in cell A2:

=VALUE(A2)

and you can apply a Custom Format of hh:mm:ss.000 to display it accordingly.

Hope this helps

Pete