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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Circuitous Relationship 3
Excel Sumproduct 0
Time Spent 2
Access 2007 - check for existing record 1
DSum in Query 1
Date/Time criteria problem 2
Monthly Summary 1
Use field to select but not group by? 4

Back
Top