Military time...

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello.

I have an Excel time format of 6:00:00 AM. I need to (1) convert to
Military Time without the ":", then convert htis time to a text value for
import into an Access Database. All attempts to accomplish this on my own
have not succeeded. Please advise of a suggested solution to this issue.

No code please.

Thank you.

NWO
 
Do you need the seconds?

A1 = 6:00:00 AM

=TEXT(A1,"hhmmss")

result as TEXT = 060000

Biff
 

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

military time 2
Military time 4
MEAN in Military Time 4
Converting Standard Time into Military Time 3
Time Cells 5
Converting Standard Time to Military Time in Excel 2
formating military time 2
Excel time conversion issue 4

Back
Top