Creating a formula

[newbie0423]

Hello,
I'm trying to write a formula that will show me the elapsed time between when a patient came out of the room until the next patient enter

 

[IanWaterman]

If they are in the same record set

@Elapsed
datediff("s",{datetimeoutfield}, {datetime in field})

This will give seconds

Ian

 

[newbie0423]

No Ian they are not in the same record set. One is the patient's out of room time and then I want to see the time difference between the next patient's in room time

 

[briangriffin]

Please don't post the same question multiple times.

This should work if the cases are sorted by In Time, and there is no grouping, etc. that you haven't described.

datediff("s",previous({datetimeoutfield}), {datetime in field})