Converting time

[akawacz]

Hi

How to convert below into readable format ?

41861.003287037
41855.001458333

I was trying this but did not work

strftime(strptime(Close"%m/%e/%Y %l:%M:%S %p"),"%Y-%m-%d %H:%M:%S")

Regards

[somesoni2 · Accepted solution]

Try something like this (assuming this is excel date )

strftime((Close-25569)*86400 ,"%Y-%m-%d %H:%M:%S")

[akawacz]

Hi

It worked thank you. Could you explain my why we substract 25569 and multiply by 86400

Thank you

[somesoni2]

The base for excel date time is 1/1/1900 and for epoch is 1/1/1970, the 25569 is the adjustment of dates (for 70 years). Multiplication by 86400 is to convert days into seconds (excel shows in days, epoch in seconds)

[akawacz]

thank you so much

[richgalloway]

What do those numbers represent? They certainly are not time strings in the format shown in your strptime command.