Hello
I want to get hours worked. I am using the below to formulas. The first one is just a straight Start Time - End Time but if that is over 30 minutes I want to use the second formula to subtract 30 minutes for Lunch. They both work but how do I put this into an iif statement. I cannot get the iif <.50 correct
=Format([MaxOfEndTime]-[MinOfStartTime]),"Short Time")
=Format([MinOfStartTime]-1-DateAdd("n",-30,[MaxOfEndTime]),"Short Time")
Thanks
L
I want to get hours worked. I am using the below to formulas. The first one is just a straight Start Time - End Time but if that is over 30 minutes I want to use the second formula to subtract 30 minutes for Lunch. They both work but how do I put this into an iif statement. I cannot get the iif <.50 correct
=Format([MaxOfEndTime]-[MinOfStartTime]),"Short Time")
=Format([MinOfStartTime]-1-DateAdd("n",-30,[MaxOfEndTime]),"Short Time")
Thanks
L