Forum Discussion
displaying time in 24 hour clock
I am trying to use the 24 hour clock to display flight departure and arrival times. I want to enter 4 consecutive digits eg: 0745 and have it displayed as 07:45. I have tried the formulas and followe...
Titian1997 put in your formatting hh:mm (if you need 24hrs format) or hh:mm AM/PM , but ensure when you are inputting time ":" should be there
if you just want regular numbers in formatting put 0000 then even if you dont put colons your number will have 4 digits , for example 745 will be 0745 , 830 will be 0830, hope this what you need