Recording Time Spent on Task

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

Guest

I Need to Record in Access, CPD time in hours and minutes.
The user will input the data via a form.
I will need to create reports showing each individual CPD record with the
time spent as well as the total CPD time.
I tried a date/time field but when creating totals this gave irrelevant
results.

What type of field should I use to record this data?
 
Hi,


DateTime is internally store in days and decimal of days... and so is
difference (interval of time) If you get 0.5, that means half a day, which
can be converted in hours by multiplying by 24.


Hoping it may help,
Vanderghast, Access MVP
 
Back
Top