In a calculated field I want to subtract a decimal number which occurs in a lookup field(called UTC Lookup) from the result of this formula [Arrival Time]-[Departure Time]
I tried this [Arrival Time]-[Departure Time]-[UTC Lookup]/24
It returns an error message saying #Type
Can anyone help with this.
Thanks
I tried this [Arrival Time]-[Departure Time]-[UTC Lookup]/24
It returns an error message saying #Type
Can anyone help with this.
Thanks