<?xml version="1.0" encoding="UTF-8" ?>
<?xml-stylesheet type="text/xsl" href="https://www.infopathdev.com:443/utility/FeedStylesheets/rss.xsl" media="screen"?><rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:slash="http://purl.org/rss/1.0/modules/slash/" xmlns:wfw="http://wellformedweb.org/CommentAPI/"><channel><title>General</title><link>https://www.infopathdev.com:443/forums/41.aspx</link><description>If you're not sure where to ask your question, ask it here. If necessary, our moderators will make sure it gets classified in the correct board.</description><dc:language>en</dc:language><generator>CommunityServer 2007 SP3 (Build: 31118.962)</generator><item><title>Calculating Difference in Minutes</title><link>https://www.infopathdev.com:443/forums/thread/99979.aspx</link><pubDate>Fri, 07 Nov 2014 22:07:00 GMT</pubDate><guid isPermaLink="false">033a2e2d-04e2-4a9d-be01-a4634161eefd:99979</guid><dc:creator>Hendrix</dc:creator><slash:comments>0</slash:comments><comments>https://www.infopathdev.com:443/forums/thread/99979.aspx</comments><wfw:commentRss>https://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&amp;PostID=99979</wfw:commentRss><description>Currently working on an time calculation form and need to calculate the difference between start time and end time.  HH:MM in 24hr format.

When the minute values in the in the Start Time field are a lower value then the minutes in the End Time field the calculations work fine.

Example:

Start Time = 16:10
End Time = 17:55
Time = 01:45:00
Decimal Hr = 1.75

However, when the minutes in the Start Time field are a higher value then the minutes in the End Time field then the time and decimal value of the calculation fail.

Start Time = 16:55
End Time = 17:50
Time = 01:5:00
Decimal Hr =1.#QNAN value

Any help would be most appreciated.</description></item></channel></rss>