This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](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(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Hi,
My time sheet is done on excel and I am hoping needing some assistance with the 24 hour formatting. When I enter my start time as 08:00 I have to enter the colon. Is there a way that I could type "0800" (for example) and have it displayed "08:00" (with the colon input automatically?
I thought I could format the cell in the "number" tab > Custom > then enter "hh:mm" as the format default. However, if I select this option, enter 0800, it displays as 00:00 in the cell. When I highlight the cell it has the following displayed: " 10/03/1902 12:00:00 a.m." Can anyone help with this?
Thanks for any help,
Ben
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Answer accepted by question author
To enter the time 8:00 as 800 or 0800 requires VBA code, there is no way to make Excel recognize it by itself. See the second part of http://www.cpearson.com/Excel/DateTimeEntry.htm
You will have to modify the code for your setup.