Sum of 'Time/date'

  • Thread starter Thread starter Pete Ashworth
  • Start date Start date
P

Pete Ashworth

im trying to get a form to add a field called [hours
worked]- which consists of each day a time inputed between
3-6 hrs and im trying to get the form to add them together
and show as a time. But when i use sum in a query, after
it hits 24 hrs, it starts over. any suggestions? Thanks
 
Best solution is to use a Number field instead of date/time.
Either store the value in hours and fractions of an hour (field size
Double), or else store it in minutes (field size Long) and use integer
division and Mod to display an hh:nn result.

More info in article:
Calculating elapsed time
at:
http://allenbrowne.com/casu-13.html
 
Back
Top