Downtime - Uptime = differencedowntime

[GregSmith]

I have 2 fields created for my downtime and uptime. When I enter the times I want the totaldowntime field to update and tell me the difference between the 2. I have been at this for some time and keep getting errors.

Any clues on how to do this??

 

[jatfill]

to display the "totaldowntime" in hours/seconds format, you can use the following:

totaldowntime: Format([uptime]-[downtime],"hh:nn")

Access 2000 converts this to "Short Time" when I run it, but you can also add seconds if you need to go that specific:

totaldowntime: Format([uptime]-[downtime],"hh:nn:ss")

 

[GregSmith]

Jatfill,

I am adding the statement: Format([uptime]-[downtime],"hh:nn") to the totaldowntime textbox under data and defualt value but it always sticks in a date instead of a time.

Any clues?