Military time...

[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

 

[T. Valko]

Do you need the seconds?

A1 = 6:00:00 AM

=TEXT(A1,"hhmmss")

result as TEXT = 060000

Biff

 

[Guest]

Excellent - thank you for the quick reply.

 

[T. Valko]

You're welcome. Thanks for the feedback!

Biff

Excellent - thank you for the quick reply.