Time cards

New Contributor
I’d like to format a cell for time input in the HH:MM:SS form. Can I format it with the two colons already in place and allow me to solely enter the 6 digits?
2 Replies


If you are not going to do any calculations with time, you may apply custom format 00\:00\:00


But the cell value will be initial number (123456), not the time value which is equivalent to 0.524259259259259 for the time 12:34:56.


Otherwise with VBA or by adding helper column to transform such number to time.

Thank you Sergei, I apologize that I did not include that I am doing calculations. I believe you answered my question though.
Related Conversations
[FIXED] Bug while trying to close tabs
HotCakeX in Discussions on
24 Replies
Time range auto fill colour
Francesc B. in Excel on
2 Replies
Teams Meeting Time Zones
David Noble in Microsoft Teams on
0 Replies