Search results

Hi, I am working with access 2007, on a formula to calculate worked hours. It covers day and night shifts and I have manage to come up with the following Billable_Hours: Format((DateDiff("s",[Time_In],[Time_Out]-DateDiff("d",[Startshift_Date],[Time_Out]))/60/60/24),"h:nn") (Note that some...