I want to add semicolon like this
Super User is a question and answer site for computer enthusiasts and power users. It only takes a minute to sign up.Sign up to join this community
09::08:00as a TIME value, also if you apply any formula then get
Below are methods, applies TWO COLON in between & SEMI COLON at end.
To convert Number or Military Time, into desire format the Formula in cell
N.B. This works if & when cell has 4 digits.
Formula in cell
N.B. This works with more than 4 digits.
Cell format applied for SEMI COLON at end.
This may be
Cell format for 2 COLON in between & SEMI COLON at end.
K110 has TIME value and cell format applied on cell
You may adjust cell references in the formula as needed.