Calculate Time spent given start time and end time

  • Thread starter Steve Murphy (Kuwait in Army**US)
  • Start date
S

Steve Murphy (Kuwait in Army**US)

I have created a InfoPath form, I have a time field ex: 09:36 for start and a
end time ex:10:56 I want to add a field that calculates the time spent. I
have added a expression box with the following formula " my:Arrival_Time -
my:Time2" However, it returns "1.#QNAN" (Not a number).

What can I do??

Steve Thank you in advance
 
N

Nic Roche

" my:Arrival_Time -
my:Time2" However, it returns "1.#QNAN" (Not a number).
Click to expand...

The values are string data types, can they be coerced as doubles/dates?


Nic Roche

"Steve Murphy (Kuwait in Army**US)"
 
Top