Dividing two time fields with h:nn format

[Eprice]

Hi,
I am still having trouble with the syntax. I am dividing three fields 'ReviewingTime' and '8Hours' and 'NoAudits'.

ReviewingTime - 33:35 (33 hours and 35 minutes)
8Hours - 8:00 (8hours)
NoAudits - 30 whole number field

If NoAudits is not null then I want
'NoAudits/(ReviewingTime/8Hours)'

I tried to get the beginning of the formula but get an error with this:
=IIf([NoAudits] Is Null,"",Format(TimeSerial(0,(Val([ReviewingTime])*60+Right([ReviewingTime],2))\[8Hours],0)),"h\:nn"))
Does anyone know the complete syntax to get the final answer.
Thanks
Lisa

 

[jbpez]

IIF(IsNull([NoAudits]=True,"",Format(TimeSerial(0,((Val([ReviewingTime])*60)+(Right([ReviewingTime],2)))\[8Hours],0),"h\:nn"))

John Borges