Adding Extra Time

[Eranka]

HI Guys

Expr7: IIf(([Work_Type]="S") And ([Location]="D"),((([Exam_Duration])+2)),IIf(([Work_Type]="I") And ([Location]="D"),((([Exam_Duration])+2)),IIf(([Work_Type]="S"),((([Exam_Duration])+1)),((([Exam_Duration])+1)))))

using the above code im trying to add 1 and 2 extra hours to [Exam_Duration], [Exam_Duration] is in time format. Please advice me how to add extra time to exam_duration??



Thanks in Advance

[Minty]

This will add 120 minutes to your time ("n" is used for minutes as "m" is already used for months !)

DateAdd ("n",120,[Exam_Duration])

[Eranka]

Hi
Minty thanks alot mate, that worked.