convert standard number to time format

T

TEA

I have a customer that whats to be able to enter time as military time 2123
w/no colons and it would be converted to a normal time format 9:23 PM
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Convert string to military time string 14
Excel does not accept text format! 0
Schedule Comparison Error - mismatch duration - "The duration you entered isn't supported for this field. type a duration in the standard format" 0
Extracting just the time portion 6
Convert time to military time? 3
Paragraph numbering in Word 1
Peculiar default cell format 1
separating date and time 5

Top