10 Replies Latest reply on Nov 6, 2018 6:58 AM by Renee Wellon

    Please delete this post/thread

    Renee Wellon

      Hi,

       

      I am having issues with the below date/time calculation.  It works perfectly to calculate the hours between two times but only if it is in the same day.  If it goes into the next day, it gives me a negative number because it is seeing it as being in the same day.  Any help is appreciated.  I am using version 10.5.2. Thanks!

       

       

      STR(CEILING(DATEDIFF('minute',[Sart Time],[End Time])/60)-1)+":"+

       

       

      STR(DATEDIFF('minute',[Sart Time],[End Time]) -

       

       

         ((CEILING(DATEDIFF('minute',[Sart Time],[End Time])/60)-1) * 60 )

       

       

          )

       

      Message was edited by: Renee Wellon