Thank you. Military time is entered, but the way it is formatted, it shows as standard time. That is not really the issue. The issue is that I need formulas to compute the number of hours in each shift no matter what the start and stop times are. I have been searching the internet and your...
Can anyone help me figure out formulas that will compute the number of hours in each shift. I downloaded a microsoft template that computes the total number of hours when the start and end times are input; however, need to know the number of hours in each shift when the shifts are as follows...