Calculating Elapsed

[Denise]

I need to calculate the amount of time from Arrival to Discharge.

This is the formula that is in the form now

=DateDiff("n",[ArrivalTime],[DCTime])/60

I am not getting the right time with this formula. What do I need to change
or do to get the correct time.

Thanks.

 

[SteveM]

Are the two values of the DateTime data type?
What output do you require?

Steve

 

[John W. Vinson]

I need to calculate the amount of time from Arrival to Discharge.

This is the formula that is in the form now

=DateDiff("n",[ArrivalTime],[DCTime])/60

I am not getting the right time with this formula. What do I need to change
or do to get the correct time.

Thanks.

What do you expect? What do you get?

The expression above will give you 0.5 if:

ArrivalTime and DCTime are Date/Time fields
Neither is NULL
They are 30 minutes apart

It will work across midnight if your fields include both the date and the
time.

John W. Vinson [MVP]