Search code examples
ms-accesstime-format

Microsoft Access time formatting

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

Solution

  • 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.