Working with time format

[mcadle]

There has to be a way and I am probably overthinking this. Anyway, I have a field where the mechanic inputs labor amount. They enter this in standard time format. I need to be able to add this time up and give a total of labor. I made the field in the table date/time and the format short time. The same has been done to the text box on the form. This works except when the labor exceeds 24 hours. Access is assuming that the time entered is an actual time of the day and not what it actually is. I have to of missed something. Does anybody know how to do this the right way?

 

[KenHigg]

Maybe the best way to do this is to just make the fld a number where a value of 1 equals 1 hour. You can still use hh:mm input masks.

kh

 

[mcadle]

You know I had tried that, but I wrote the input mask like this:

00:00;

Can you do:

hh:mm;

If you could I bet that would work.


UPDATE:

Nope just tried it. The problem with number field then they can enter 99. well obviously there aren't 99 minutes in an hour. I have been trying through code to make it chop off at 60 and add 1 to the hour. Any ideas?

 

[maxxximaniac]

i made a database like what you are referring to for a manager to calculate time... i can give you the DB if you want... and you can make whatever changed u want...

u can PM me if u want...

 

[mcadle]

BUMP..

Max I never received the DB. Can you try again? Or if anybody else has any ideas?