Creating a Formula using Time

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top