Home

Time cards

%3CLINGO-SUB%20id%3D%22lingo-sub-797504%22%20slang%3D%22en-US%22%3ETime%20cards%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-797504%22%20slang%3D%22en-US%22%3EI%E2%80%99d%20like%20to%20format%20a%20cell%20for%20time%20input%20in%20the%20HH%3AMM%3ASS%20form.%20Can%20I%20format%20it%20with%20the%20two%20colons%20already%20in%20place%20and%20allow%20me%20to%20solely%20enter%20the%206%20digits%3F%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-797504%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-797735%22%20slang%3D%22en-US%22%3ERe%3A%20Time%20cards%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-797735%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F389880%22%20target%3D%22_blank%22%3E%40Swyrv%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20you%20are%20not%20going%20to%20do%20any%20calculations%20with%20time%2C%20you%20may%20apply%20custom%20format%2000%5C%3A00%5C%3A00%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F126419i246B25C86BD52AEC%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22clipboard_image_0.png%22%20title%3D%22clipboard_image_0.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EBut%20the%20cell%20value%20will%20be%20initial%20number%20(123456)%2C%20not%20the%20time%20value%20which%20is%20equivalent%20to%26nbsp%3B0.524259259259259%20for%20the%20time%2012%3A34%3A56.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EOtherwise%20with%20VBA%20or%20by%20adding%20helper%20column%20to%20transform%20such%20number%20to%20time.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Swyrv
Occasional Visitor
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?
1 Reply

@Swyrv 

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

clipboard_image_0.png

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.