G
Guest
I know very similar questions have been asked, and I searched and read
through all the links...my answer is probably somewhere in there but I must
be missing it. Please help!
I have a form that needs to keep a running sum of hours (including minutes)
used. Client starts out with a set number of hours and hours:minutes are
subtracted as they are used. Right now the field is a number data type
because access will not let the user enter an hour format over 24 hrs. For
example, client has 100 unused hours, I need to subtract 50:45 (fifty hours
and 45 minutes) for a resulting total of 49:15.
Users will need to enter hours in the format hours:minutes. Any
suggestions would be very appreciated.
through all the links...my answer is probably somewhere in there but I must
be missing it. Please help!
I have a form that needs to keep a running sum of hours (including minutes)
used. Client starts out with a set number of hours and hours:minutes are
subtracted as they are used. Right now the field is a number data type
because access will not let the user enter an hour format over 24 hrs. For
example, client has 100 unused hours, I need to subtract 50:45 (fifty hours
and 45 minutes) for a resulting total of 49:15.
Users will need to enter hours in the format hours:minutes. Any
suggestions would be very appreciated.