Can someone please help me figure out two formulas. Columns E and F would be entered manually as military time. Column G would have to add any hours between E and F where column E would have a time between 14:01 and 4:59. Column H would need to calculate hours where column E would have a time between 5:00 and 14:00. Please help as my job entails alot of the HR timekeeping along with my operational management. Column L would calculate total hours. Thanks in advance for your help.Timesheet1.xlsx
Bookmarks