I have a document that has cells to formulate total days in house. We have a cell next to that that puts in the actual time it left. We want the cell that formulates the total days in the house to add an extra day if it left after 11:00 PM (as it will not actually leave until the next day). I have the following formula in the cell to calculate the formula, yet it will not add the extra day if past 11:00 - see chart for information:
Column G column J Column K Column L
date entered date out time shipped days in house
05/11/11 05/18/11 23:45:00 7
My formula is =IF(K50>"23:00:00",J50-G50+1,J50-G50)
For reference, I have tried changing the times to show 11:45 pm, and that did not work. Thanks!!
Column G column J Column K Column L
date entered date out time shipped days in house
05/11/11 05/18/11 23:45:00 7
My formula is =IF(K50>"23:00:00",J50-G50+1,J50-G50)
For reference, I have tried changing the times to show 11:45 pm, and that did not work. Thanks!!
