Adding number and colon in a time format

0

How can you add number and colon before a number in time format?

e.g. I have 7:48 which is 7 minutes 48 seconds. I want to add hours to it to make it look like 00:7:48.

Answer
Discuss

Answers

0
Selected Answer

Right-click the cell > Format Cells > on the General tab click Time from the left section and select the desired format.

Discuss

Answer the Question

You must create an account to use the forum. Create an Account or Login