Time formatting in Excel
Time formatting in Excel
(OP)
My excel spreadsheet has data for every tenth of a second for about an hour and a half; around 45000 cells. The data that was given to me has a flaw; when the hour gets past 12:59:59am it jumps back to 12:00:00 am. I need the hour to read 01:00:00am so that I can subtract the time intervals correctly since the minutes and seconds are different for every reading. I have tried to format the cells to only read mm.ss.0 but excel still recognizes the hour. Is there any way to change the hour and not the minutes and seconds without having to manually do it 45000 times?





RE: Time formatting in Excel
TTFN
RE: Time formatting in Excel
RE: Time formatting in Excel
Another option may be to reset the system time so that the clock starts at 1:00 am. This is assuming that you are using the system clock for reference and the same problem won't occur at 2:00 am.
RE: Time formatting in Excel
Copy them into another column
Replace the entries after the rollover with a reference to the copied serial numbers plus 1/24
TTFN
RE: Time formatting in Excel
RE: Time formatting in Excel
m777182