I tried. If you type HH:NN access will automatically change it to "Short Time" which removes the leading 0make a custom format hh:mm
Im access 2010. If you type HH:NN in the format field it changes automatically to "Short Time" which is not what I want it to do. I need the leading 0I just tried and it works well.
excel 2013
This is the access forumAccess? This is for excel.
This is the access forum
Forum
Question Forums
Microsoft Access
Trouble with time format
Whoops, my mistake. I am a noob with access.