How do I keep a running track of time?

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

Guest

I am writing a database that needs to keep track of time each day and then
add it to total amount of time worked. If you set up the field as time, when
you get to 24 hrs. of total time, the program rolls back to 00 hrs. on the
next day. Can anybody help me figure this out so I can keep a running track
of time.

Thanks,

Denis Ratekin
 
If it were me I'd convert the elapsed times to minutes and store that as the
time worked. As long are you do not have to keep track of either very short
or extremely long periods (like multiple millennia) you probably will do
well. It is easy to convert start and stop times to minutes (see DateDiff
function) and simple math to convert minutes into Days and Hours.

Ron W
 
Back
Top