Hi, I need to subtract a TIME(a1, b1, c1) value from a clock time in "D1" and have the function work backwards over midnight. I have searched excel formula books, searched this board, and looked on-line with no clear examples. Is there a "function" I can use, or will a macro be required?
thanks in advance!
thanks in advance!