Excel VBA Course
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.)

View Course

Leading Zero for 24 hrs time (Military time) (Whiskey or Zulu time)

0

See title says it all????.

Thanks : Garymore

Answer
Discuss

Answers

0

Hi Gary and welcome to the Forum

Put a time in a cell or some cells. With those selected, right click and select Format Cells... With the Number tab displayed, under Categories list, click Custom. Then in the Type box (above the various formats)  type hhmm and click OK. You'll get results like 0103 in your worksheet or use hh:mm for results like 01:03 (but the formula bar will still show the "normal" Excel time 01:03:00).

Use hh:mm"hrs" instead if you want the cell to appear as 01:03hrs (as it's sometimes spoken).

That's it and Excel will be able to do time calculations on the cell.

Discuss

Discussion

Did that work for you, Gary?
John_Ru (rep: 6102) Mar 12, '21 at 12:23 pm
I have a tablet so my Excel does not come with a right click.  This version does not come with custom in the numbers format.  The "' " "  works but is there a way to address the whole workbook at one time? 

Thank you for your help gary more 
GaryMore Mar 12, '21 at 12:40 pm
Not sure how to do that on a tablet (or on my phone version which has a Special category for formatting but it's ghosted).

On a PC, you can format all cells in a workbook by shift-click selecting all sheets then clicking on the square between column headers (A, D..) and rows (1,2...) to select the whole sheet (and so all sheets) then applying the formatting.

Sorry I couldn't help you more
John_Ru (rep: 6102) Mar 12, '21 at 4:51 pm
Add to Discussion


Answer the Question

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