Hi! I need help on formula for excel on how to calculate total hours and days worked within the office hours (M-f 7:30am to 7:30PM) and Sat(7:30am to 1:30PM). computation will be based on start date&time and end date&time e.e Start = 1/8/15 3:46 PM and End = 1/12/15 5:09 PM. I tried so many formulas but none is working right. Thanks in advance!