General discussion
July 13, 2005 at 09:40 AM
gsteve

Access: time format question

by gsteve . Updated 21 years, 2 months ago

I have a text box on a form where I would like to use a time format that shows hours greater than “23:59” (i.e. hours worked in a week = 40:00). Unfortunately, when I use hh:mm format, I get “15:00”) is there an easy work around for this?

In Excel, I use the time format: [h]:mm:ss
…but access doesn’t like it when I put that in the format property.

Thanks in advance for your help!

This discussion is locked

All Comments