I know the formula for adding time which is:
+TIME (hours, minutes, seconds).
I need to know the formula/code to add TIME to a cell if the cell passes through a fixed time.
For example:
If cell A1 is 9:00AM and cell A2 is 5:00PM, how do I add 15 minutes to 5:00 to make it 5:15PM without having to manually add it everytime? The 15 minutes would be a break during the working shift.
But if cell A1 is 8:00AM and cell A2 is 10:00AM I would not want to add the 15 minutes.
Any help would be appreciated. Thanks!
+TIME (hours, minutes, seconds).
I need to know the formula/code to add TIME to a cell if the cell passes through a fixed time.
For example:
If cell A1 is 9:00AM and cell A2 is 5:00PM, how do I add 15 minutes to 5:00 to make it 5:15PM without having to manually add it everytime? The 15 minutes would be a break during the working shift.
But if cell A1 is 8:00AM and cell A2 is 10:00AM I would not want to add the 15 minutes.
Any help would be appreciated. Thanks!
