Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. SmilyLex

    thread181-1435685 solution for s

    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...
  2. SmilyLex

    thread181-1435685 solution for s

    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...
  3. SmilyLex

    thread181-1435685 solution for s

    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
  4. SmilyLex

    thread181-1435685 solution for s

    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...

Part and Inventory Search

Back
Top