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.