Software

Ask something
Discussion Locked

Access: time format question

0 helpful
5 replies

by gsteve

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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!

5 replies

by gsteve

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

by parier

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 eparisek@eparisek.com 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!

This discussion is closed to new replies.