Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
thanks in advance
change your expression to
(DDT_Hours)*[Personnel Expected]
and change the format to Time->hh:mm from the number tab
it works
Hi
i have already changed this and it just shows 00:00 for all values now! are you able to amend the example?
thanks Jebamalai
Hi James
Pls check and let me know
Regards
Jeba
Hi Jeba
The third calculation isnt correct it should show 50:00, it shows 02:00 in the example
regards
James
Oh sorry.
Pfa the updated one
Hi Jeba
that's perfect thanks for your help
regards
James