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.
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
Adding number and colon in a time format
0
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.