Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Time displaying wrongly
Hi all
When I enter 6.30 in a cell to indicate 6.30am the display has changed to 7.12am? I have gone to the format time menu and keep changing it to the various types on offer but still it comes up as 7.12? I have tried other times and the same thing happens, 11.20 appears as 4.48!!!! My computer time and date settings are ok, can anyone suggest why this is happening please? Otherwise I will just have to continue using general numbers in the formatting. Thank you Denise |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Time Sheets | New Users to Excel | |||
Adding time | Excel Discussion (Misc queries) | |||
More problems displaying a negative time | Excel Discussion (Misc queries) | |||
unmet challenge | Excel Worksheet Functions | |||
displaying several charts, one at the time | Charts and Charting in Excel |