Home

Data scenario with hours displays 12:00 on another PC

sjlouis
New Contributor

Hi,

 

I changed my PC but on this new one, when I open a file with a scenario with hours, all the hours are displayed with 12:00.

 

If I enter a new hour and save the file, all the data except the last one are stored with 12:00 (I verify it with the old PC).

 

I've searched in Excel options and on Internet but I don't find anything.

 

Thank you.

Jean-Louis

3 Replies

I've done another test and I've created another scenario with hours. When I open again the scenario, I don't see hours as 18:00 but as 0.75 in the scenario, but it's good in the sheet.

 

And now, when I open the file I've created on the other PC, I can see the good hours in the scenario and not 12:00. It's not very understandable.

Highlighted

Did you format the cell as HH:mm ?

Yes, in the file I've taken from the previous PC, it have the cells in the sheet formatted with hh:mm.

 

And with the new files on the second PC, I've done 2 tests :

- I've formatted the cells in the sheet before creating the scenario.

- I've formatted the cells in the sheet after creating the scenario.

 

There is the same result. I haven't found how to change the cells format in the scenario.

 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
38 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
12 Replies