Downtime showing negative time

[MFS]

Hello everyone,


I'm trying to get downtime in a query to show actual downtime.
For example, if a machine goes down @ 10:30pm and returns to production @ 1:00am my query shows it as being down for -21.5 hours. When the equipment was actually down for 2.5hrs.
What can I do to correct this issue?
The fields in my table are . . .Cell reported down at what time and Repair completed at what time

Thanks in advance, I'm sure this is probably an easy one!!!!

[RuralGuy]

How about this link? http://access.mvps.org/access/datetime/date0004.htm

[MFS]

That looks to be working, thanks for your help RuralGuy

[RuralGuy]

Excellent! Glad we could help.