I am having difficulty finding any error with my formula.
This formula is supposed to give a time in days:minutes:hours format. When I run this formula as it is I get a result of 1:00:00 when it should be 32:00:00. If I delete the last nested IF (after the third "+") the formula yields the correct result of 24:00:00. I have also replaced the last nested IF with a "7" and got 31:00:00. If I replace it with an "8" i get the incorrect 1:00:00 again. If I replace it with a 9 I get 2:00:00. Why is this giving wrong return values when and after I reach a value of 32?
Formula in question is in Column F of the sample. I will add that when Inputting values into Column B they are in this format: "1/1/1900 12:00:00 AM"
Edit: Changed to sample per request.
Bookmarks