convert standard number to time format

G

Guest

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

macro to change text to time 1
Time Format 5
Convert QuickBooks time format to excel to calculate 2
Extracting just the time portion 5
formatting cells for time 1
Inputting Time 2
Calculating Difference Between Two Times in General Format 4
Calculate Ending time using Start Time and Elapsed Time 5

Top