Adding Short Time?

[Joe K]

New to access so please be patient. I am making a database to track
employee's overtime. I have an employees table and an overtime table. On the
overtime table there is one column for date, one for time earned and one for
compensation (cash or time). The amount of time earned is entered in short
time (6:25 - 6 hours 25 minutes). I would like to calculate totals for month,
quarter and year in both types of compensation. Any ideas? Thanks in advance.

 

[Jeff Boyce]

It isn't clear from your description...

It sounds like your "time" field in your table is of type date/time. If
you, you'll need to change it, because Access Date/Time data is
"point-in-time" data, not "duration" data.

If your "time" data is actually a text field, you will need to come up with
a procedure that parses a text string like "6:25" into 25 + 6*60 (i.e., a
number).

Regards

Jeff Boyce
Microsoft Office/Access MVP