How do I show hours and minutes in a time card i.e.: 40:32 weekly

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am building a database for a trucking company, and when I use the Short
Time for the time card, it will not let me input anything over 23:59 and it
does not add the weekly hours correctly. It must be on a 24 hour cycle: so,
22:30 plus 10:15 adds up to 8:45...... instead of 32:45 like it should.

Any ideas?
 
Connie said:
I am building a database for a trucking company, and when I use the
Short Time for the time card, it will not let me input anything over
23:59 and it does not add the weekly hours correctly. It must be on
a 24 hour cycle: so, 22:30 plus 10:15 adds up to 8:45...... instead
of 32:45 like it should.

Any ideas?
Click to expand...

The DateTime DataType is for storing a "point in time" not an "amount of time".
To store durations you should either store a StartTime and EndTime in separate
fields or else store the number of (minutes, secods or hours) as a numeric
value.
 
You should store your values as long integer (or integer) values that
represent the total minutes for an entry. Then you can display the results
the way you wish (using Format, calculations, etc.) based on the minutes,
but your additions will properly add minutes and not "time".
 
Back
Top