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