Apr 6, 2013 #1 kevinday1 Programmer Mar 30, 2013 4 US I have 2 time variables eg 20:20 and 08:30 how do I find out how many mins in between cheers
May 3, 2013 #2 cagiv Programmer Mar 5, 2009 56 DE In your case: ROUND((DEFORMAT('20:20',@T1) - (DEFORMAT('08:30',@T1) + 8640001))/(-6000),.01) -> 730 min cagiv Upvote 0 Downvote
In your case: ROUND((DEFORMAT('20:20',@T1) - (DEFORMAT('08:30',@T1) + 8640001))/(-6000),.01) -> 730 min cagiv