Issue Subtracting Time

[Liz_I3]

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

 

[Liz_I3]

I got this to work, but if anyone has a better method I would appreciate any ideas

=IIf(DateAdd("n",30,[MinOfStartTime])>[MaxOfEndTime],Format(([MaxOfEndTime]-[MinOfStartTime]),"Short Time"),Format([MinOfStartTime]-1-DateAdd("n",-30,[MaxOfEndTime]),"Short Time"))

Thanks
L

 

[Micron]

In order to explore this, I think we'd have to know the data type for MinOfStartTime, etc. It could be DateTime or long, or integer. Or maybe something else.
It's kind of a curiosity, because you're using the built in format of Short Time in an expression, while I think you could set that in the table field - unless that field isn't Date/Time.