DateDiff

[Yarg]

I am trying to create a form which determines how long a machine has been in a specific state (UP, Down, etc.)

I get a response back from the DateDiff function but it returns a Julian Date and I need it in hours, how do I convert?

 

[pdldavis]

Hi, you might try something like this : =DateDiff("h",[txtup],[txtdown])

where the "h" is the interval in hours, [txtup] is hours machine is up and [txtdown] is the hours machine is down.