Search results for query: *

I'm happy with my final solution. Many thanks for all the suggestions. Any overnight (mid night) hours worked are more complicated to pay penalties for so identifying which shift go over midnight is the start of the calculation and may end up with far too many rates or portions of. Regular...

What I needed is BasePay: IIf((DateDiff("n",[Start1],[End1],1,1)/60<0), ((DateDiff("n",[Start1],[End1]+1)/60)*[Employee]![BaseRate]), (DateDiff("n",[Start1],[End1],1,1)/60)*[Employee]![BaseRate]) It gives me regular day time gap x $pay Rate or overnight Time gap x $pay rate remove the Pay...

Thanks Maj The final result I need is Either (same day time gap X $rate) as well as (Overnight time gap x $rate). Thus I need an decimal result so I can run an Iif query to sort which of 23+ category base formulas I need to apply to calculate wages. Cheesrs Alex

thread181-1435685 solution for simultaneously dealing same day as well as overnight start and end time within 24hrs of each other (only One problem) HrsWrked: IIf((DateDiff("n",[Start1],[End1],1,1)/60<0),(DateDiff("h",[Start1],[End1]+1) Mod 24),DateDiff("n",[Start1],[End1],1,1)/60) The mod...