Military time format need to include seconds

[vad77]

I am currently working on a database where my source data has the times in military format which includes the seconds; 18:45:30. All my time fields are set to data/time and format is Short Time. The Short Time format gives me military time but only down to the minute. I need to include the seconds into my time fields. I tried creating an input mask but it converts it to standard time.
Does anyone know how I can show military time down to the seconds as in my example above?
Thank you in advance for your responses.

Vito

[orange]

You could try LongTime format

[vad77]

I tried Long Time format but when you enter time in military format it converts it to standard time. 18:30:45 --> 6:30:45 PM

[orange]

If you are in a different time zone, you will have to set a MilitaryBaseTime value.

?Format(Time,"HH:NN:SS")
09:38:22

If your military time is 4 hrs ahead of local time (add 4 hours as MilitaryBaseTime)
?format(Dateadd("h",4,Time),"HH:NN:SS")
13:38:22

You can try this which has been suggested for military time in other posts.
?Format(Now(), "hhnn")
0942

[vad77]

Thanks I will try that formatting. This may all be for nothing as I finally got a copy of sample data and time is not in military and switched back to a standard time format. But at least if they change their minds I would have a solution.