Calculate Time spent given start time and end time

[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

 

[Nic Roche]

" my:Arrival_Time -

my:Time2" However, it returns "1.#QNAN" (Not a number).

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


Nic Roche

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