Hi All,

I'm working on a fault managment DB.

I need three fields:

First: Date and Time fault was opened
Second: Date and time fault was resolved
Third: Total time fault took to resolve

I'm sure its a simple calculation, I've been unable to figure it out.

Is this possible and how?

Rgds,
Adolph

Dolphy wrote:

First and second field are timestamp fields.

Third field is a calc field: SecondField - Firstfield. This will get you
the number of seconds between the two moments, so you will often gaze at
some horribly high number

Set the calc field to time result. You will see some hh:mm:ss. The
simplest way to display the number of days is create another calc field.
--
http://clk.ch