1. Go to work time: 8:30 am - 12:00, afternoon: PM - 17:30pm, want to set a formula, can enter the start date and end date and start time and end time, directly and leave time (minutes),
2. On the same day, there are two hours of rest time at noon; Across the day, the same in the afternoon after work, how to use a formula to solve the same day and days for leave time?
Ask for leave 3. There are three categories, respectively is: personal leave, travel expense and general holidays, how to ask for leave by choosing a category, let off hours behind automatically displayed in the corresponding cell?

CodePudding user response:

Directly to do subtraction, EXECL are very smart