Could someone help with the correct time formatting. I am using Microsoft Access for 365 installed in the PC (64bit version)
The time is comming from a linked server as military format with the exception of middnigh or passed midnight the format comes as 1000 (without the 2 digits at the begining) (instead of 001000 or 241000) (see pics) So I'm trying to format in a way the is a easier visual as 00:10:00 or 24:10:00
Thank you before hand for any help
Example Link image
This is the format for time desired
Use TimeSerial
to convert your "numerical" time to true time values:
TrueTime = TimeSerial(NumTime \ 10000, NumTime \ 100 Mod 100, NumTime Mod 100)
Then apply the format to this as you like.