SOLVED

Time cards

Copper 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
best response confirmed by Swyrv (Copper Contributor)
Solution

@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.

Thank you Sergei, I apologize that I did not include that I am doing calculations. I believe you answered my question though.
1 best response

Accepted Solutions
best response confirmed by Swyrv (Copper Contributor)
Solution

@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.

View solution in original post