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

Image link

CodePudding user response：

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.