Time Calculations

[#1]

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

[Anonymous]

change your expression to

(DDT_Hours)*[Personnel Expected]

  and change the format to Time->hh:mm from the number tab

it works

[#3]

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

[Anonymous]

Hi James

Pls check and let me know

Regards

Jeba

[#5]

Hi Jeba

The third calculation isnt correct it should show 50:00, it shows 02:00 in the example

regards

James

[Anonymous · Accepted solution]

Oh sorry.

Pfa the updated one

[#7]

Hi Jeba

that's perfect thanks for your help

regards

James