I am testing a default SP Designer 2010 workflow action called "Find Interval Between Dates" located under the "Utility Actions" category. I need to compare the amount of time passed between the current item's last modified date and the current date.
At first I tried finding the number of days in the interval, and I get a strange value like ".47" even though the interval I was testing should have been about 3 days. Then I tried hours, and this second test was with an items that had been modified only about 5 minutes ago, so I expected a small fraction for "hours", but my test returned "11.23". What is going on here?