Add Time

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

Guest

I have short time fields, instead of adding up at the bottom they start over
in a day period. When it adds 22:00 to 20:00, it calculates 18:00. I want
it to add to 42:00. How do I get it not to value a day and just add all
together. Any way to format the field?
 
dogpigfish said:
I have short time fields, instead of adding up at the bottom they
start over in a day period. When it adds 22:00 to 20:00, it
calculates 18:00. I want it to add to 42:00. How do I get it not to
value a day and just add all together. Any way to format the field?
Click to expand...

Access Date/Times are for storing "points in time" not "amounts of time".
To store durations you should use a numeric field and store the total number
of seconds and then use an expression to convert this to hours, minutes and
seconds for display.
 
I figured it out on my own, I simply turned the field into a "general number
format" and then divided by 24. Pretty easy, thanks for the cosnideration.
 
Back
Top