A
Annamei
I am attempting to create a formula using Time, the field is not returning
the correct information, I have tried it without the colon in the time field
and it worked but I would like to include the colon.
i.e.:
TimeOut - TimeIn + TravelTime = TotalTime
when I enter
10:50 - 09:20 + 00:33 = NaN
when I enter
1050 - 0920 + 0033 = 163
Any suggestions? I am using Info Path 2003
the correct information, I have tried it without the colon in the time field
and it worked but I would like to include the colon.
i.e.:
TimeOut - TimeIn + TravelTime = TotalTime
when I enter
10:50 - 09:20 + 00:33 = NaN
when I enter
1050 - 0920 + 0033 = 163
Any suggestions? I am using Info Path 2003