M Madhu Joined Jun 13, 2005 Messages 3 Reaction score 0 Jun 13, 2005 #1 Hi, Can anyone helpme oconvert the date in excel to milliseconds. Thanks Madhu
Ian Administrator Joined Feb 23, 2002 Messages 19,877 Reaction score 1,508 Jun 13, 2005 #2 How exactly do you mean? Milliseconds from the current date? Also, what format is the date in?
M Madhu Joined Jun 13, 2005 Messages 3 Reaction score 0 Jun 13, 2005 #3 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
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 Administrator Joined Feb 23, 2002 Messages 19,877 Reaction score 1,508 Jun 13, 2005 #4 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)?
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)?
M Madhu Joined Jun 13, 2005 Messages 3 Reaction score 0 Jun 13, 2005 #5 yes exactly.. it si the date and time.