LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

Excel time formatting

Solved!
Go to solution

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?

2.JPG

1.JPG

  

 

0 Kudos
Message 1 of 11
(1,747 Views)

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

Jorge Augusto Pessatto Mondadori, PhD
Sistema Fiep
CLAD, CLD
0 Kudos
Message 2 of 11
(1,710 Views)

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)
========================
=== Engineer Ambiguously ===
========================
0 Kudos
Message 3 of 11
(1,701 Views)

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.

========================
=== Engineer Ambiguously ===
========================
0 Kudos
Message 4 of 11
(1,697 Views)

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. 

0 Kudos
Message 5 of 11
(1,689 Views)

I think he should have said .000

 

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

0 Kudos
Message 6 of 11
(1,686 Views)
Solution
Accepted by topic author msabah38

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!)

 

x1Capture.PNG

 

A proper timestamp, the raw numbers change with time

 

 X2Capture.PNG

 

========================
=== Engineer Ambiguously ===
========================
0 Kudos
Message 7 of 11
(1,683 Views)

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

msabah38_0-1622646696596.png

 

0 Kudos
Message 8 of 11
(1,679 Views)

@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!

 

X3Capture.PNG

 

X6Capture.PNG

========================
=== Engineer Ambiguously ===
========================
0 Kudos
Message 9 of 11
(1,676 Views)

Thank you, Got It.

0 Kudos
Message 10 of 11
(1,672 Views)