Hello,

I'm new to Excel programming, but a very experienced Access-programmer.

I want to do some time calculation in Excel, but am already stuck with the if syntax.hat is the syntax for the following expression ?


If (timevalue in cell B6 > 17:45 then (17:45 minus timevalue in B2) else (timevalue in cell B3 minus timevalue in cell B2))

Any help will be greatly appreciated.

Thanks,

W