What happens if you format the cells for the time (for example a column) as hh:mm before populating them?
Excel - Date / Time Formatting Issue
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(99.2, 76%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAI%3C/text%3E%3C/svg%3E)
Ainslie Innes (James Slater & Co)
0
Reputation points
Hello,
I am not very experienced with Excel, but I have managed to create a spreadsheet that logs my working hours.
Every time I enter a new time, the cell automatically reformats to date & time. The formulae still display the correctly but it is going to be very frustrating to have manually re-format the cell to hh:mm
Is there something I have missed?
Microsoft 365 and Office | Excel | For business | Windows
Accepted answer
-
HansV 460.6K Reputation points MVP Volunteer Moderator2025-08-11T13:23:18.51+00:00 -
Ainslie Innes (James Slater & Co) 0 Reputation points
2025-08-11T13:47:02.86+00:00 Hi,
Thank you for you prompt response.Ah that is colossally embarrassing! Yes clearing the content of the cell and entering the time has resolved the issue!
I had not realised the colon between the "hh" and "mm" components were so necessary.
Sign in to comment -