How to convert Date/Time in String format to Timestamp format

[Elyan_wisam]

Hi 

I need to now how to  convert Date/Time in String format to Timestamp format

I have time in this format 14:56:13 its as string  also I have another string sec time 14:55:13

what I need to do is to subtract first time from sec time and the result should be 20 sec

14:56:13 - 14:55:53 = 20 

who I can do that, since the time that as have is as string 

thanks for you help  

[GerdW]

Hi Elyan,

you surely have heard about the ScanFromString function, don't you?

With timestamps you can do simple math like subtract them…

[Elyan_wisam]

thanks alot

Spoiler