Home > Mobile >  Microsoft Access time formatting
Microsoft Access time formatting

Time:12-17

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.

  • Related