 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / General MS InfoPath Questions / November 2006Creating a Formula using Time
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 Try this article: http://enterprise-solutions.swits.net/infopath2003/article.php?t=time-calculatio ns-using-rules&c=infopath2003 --- S.Y.M. Wong-A-Ton > 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 [quoted text clipped - 9 lines] > > Any suggestions? I am using Info Path 2003 |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.