Excel time formatting

[msabah38]

I have a excel sheet, where the first column has date and time in the format dd/mm/yy hh:mm:ss AM/PM (For example 02/06/21 03:50:12 PM). I want the to change the time format to show millisecond also. How can I do that?

  

[jorgemondadori]

Hey, if you have a timestamp that gives you information on seconds, just multiply for 1000. also if you need to convert to unix timestamp, found this link on google:

https://www.extendoffice.com/documents/excel/2473-excel-timestamp-to-date.html

[RTSLVU]

Well this is a question better asked in an Excel support forum but...

1. Select the column you want to format
2. Right click on the column and select "Format Cells" from the pop-up menu
3. Select "Custom Format"
4. Then select the time format you want (it won't have the mS)
5. Add an "s" for as many mS decimal places as you want to the time format (h:mm:ss.sss)

[RTSLVU]

I hate to break it to you but your timestamp is invalid in your Excel file.

So you can't fix this by simply reformatting it.

[msabah38]

How is the timestamp invalid, it is able to show date, month and year, hour, minutes and seconds, AM and PM based on the format we choose. 

Tried adding ".sss" after ":ss" but it did not work. Can you make a excel which has timestamp having millisecond. 

[RavensFan]

I think he should have said .000

This format works for me:    h:mm:ss.000 AM/PM

[RTSLVU · Accepted solution]

I tried changing the format of the file you attached and could not format it.

If I remove all formatting your time stamps look like this (all the same time!)

A proper timestamp, the raw numbers change with time

 

[msabah38]

I copied and pasted your format (h:mm:ss.000 AM/PM), but it didn't work for me, can you share your screenshot.

[RTSLVU]

---

@msabah38 wrote:

I copied and pasted your format (h:mm:ss.000 AM/PM), but it didn't work for me, can you share your screenshot.

---

Because as I said the timestamps are invalid in the data file you attached!

[msabah38]

Thank you, Got It.