Skip to Content
0
Jul 09 at 06:51 PM

Unrecognized input 'HH' at position 59 (IES 10022) , why, for correct formula?

123 Views

Not sure what's wrong with the formula, trying to get the difference in date/time in minutes, please help!!

=(ToNumber(SubStr(FormatDate([Bed Assigned Date Time] ,"HH:MM:SS") ,1 ,2))*60) + (ToNumber(SubStr(FormatDate([Bed Assigned Date Time] ,"HH:MM:SS"), 4, 2))) + (ToNumber(SubStr(FormatDate([Bed Assigned Date Time] ,"HH:MM:SS"), 7, 2))/60) - ((ToNumber(SubStr(FormatDate([Last Bed Requested Date Time] ,"HH:MM:SS") ,1 ,2))*60) + (ToNumber(SubStr(FormatDate([Last Bed Requested Date Time] ,"HH:MM:SS"), 4, 2))) +(ToNumber(SubStr(FormatDate([Last Bed Requested Date Time] ,"HH:MM:SS"), 7, 2))/60) +((DaysBetween([Bed Assigned Date Time];[Last Bed Requested Date Time])*24)*60)