Excel Convert date to milliseconds in Excel

[Madhu]

Hi,
Can anyone helpme oconvert the date in excel to milliseconds.

Thanks
Madhu

 

[Ian]

How exactly do you mean? Milliseconds from the current date?

Also, what format is the date in?

 

[Madhu]

Hi,
The date is in the format 06092005120400. I want thsi to be converted to milliseconds from Jan 1 1970.
It would be great if you can help me out

Thanks
Madhu

 

[Ian]

What format is 06092005120400?

DD/MM/YYYY for 06092005 I presume, but what is 120400? is that 12:04:00 in hours (24 hour type)?

 

[Madhu]

yes exactly.. it si the date and time.