General discussion


Access: time format question

By GSteve ·
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 conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

by GSteve In reply to Access: time format quest ...

Yeah...I forgot to include this information: I am working on a Windows 2000 PC, with Access XP.

Collapse -

by GSteve In reply to Access: time format quest ...

Point value changed by question poster.

Collapse -

by parier In reply to Access: time format quest ...

Hmm, Not sure how or why you would want to use clock time as total hours. I dont see an easy, logical way of completing this task. There are two items here. 1. You want to calculate time, but using clock hours. Logically, this is not possible. BUT, you can make it LOOK like it is.

I would convery the time for decimal, do the math, then the answer can be converted to HH:MM using a format and concatenation. I did something similar in Excel. Users can type 0000, 0115, 0345, 1600, 1845, etc and it will calculate the total hours per day. Only issue is I used 15 culomns to get from Clock time to decimal hours. Standard Excel has no conversion for what I needed. If you require a more explicit explanation, please send an email to along with the database, with or without the data, or partial data...and we can work together on this.

Hope all else helps and good luck!

Collapse -

by GSteve In reply to

Poster rated this answer.

Collapse -

by GSteve In reply to Access: time format quest ...

This question was closed by the author

Related Discussions

Related Forums