15 Replies Latest reply: May 19, 2014 7:08 AM by James Clark RSS

    Time Calculations

      Hi All

       

      I need to find out how I can multiply a number of hours by expected personnel, to get total hours booked to event.  the calculation to get the Hours are

      if(interval(EndTime - StartTime,'hh:mm')<0, interval(Date(EndTime,'ddmmyy')+1 - StartTime,'hh:mm'),interval(EndTime - StartTime,'hh:mm') )as [Total_Hours] and the personnel Expected is a sum of numbers.  so the total booked hours should be 21:00, but I cant workout how I can calculate a time calculation by a number calculation. am i missing something

       

      can anyone help.

       

      Capture.JPG.jpg

       

      thanks in advance