DateDif calculation

[ssworthi]

My user would like to have lunch of 30 minutes be part of the calculation for hours worked. Is that an IIF calculation or can that work in the
DateDiff calculation. Thank you so much. This works, I just haven't calculated the 30 minute dedcution if the lunch box is clicked (true).
Hours: DateDiff("n",[Start time],[End time])/60

[JoeM]

Assuming the "Lunch" is a Boolean field (Yes/No or True/False) and lunch is always 30 minutes, you can work it into the calculation like this:

Hours: DateDiff("n",[Start time],[End time])/60 - IIf([Lunch],0.5,0)

[CJ_London]

I think you want a dateadd function

DateDiff("n",[Start time],[End time]) gives you total time between the dates, (i.e. lunch included) so you need to deduct 30 minutes if it is not included

Hours: DateDiff("n",[Start time],dateadd("n",iif(lunchbox=true,0,-30),[End time]))/60