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
If you want to format it, you should put the formatting function as the outermost function.
Secondly, if EndTime and StartTime are correctly interpreted, they have numeric values where a difference of one day is 1, and a difference of one hour is 1/24. This means that you can get the number of hours through