Subtracting Times when passing midnight

[dispatchergirl911]

=IF(OR(ISBLANK(P2),ISBLANK(O2)),"",P2-O2) is the current formula I am using to subtract times and leave the cell blank if target cells are blank. This works perfectly 99% of the time, the issue I am running into is when a call runs through midnight. I need to be able to add (P2>O2).

Ex: =IF(OR(ISBLANK(P2),ISBLANK(O2)),"",P2-O2,p2>O2) or =IF(OR(ISBLANK(P2),ISBLANK(O2)),"",P2-O2,(p2>O2))

I am getting an error saying I've entered too many arguments for this function. Any ideas?

 

[mole999]

lots of examples here > https://www.ablebits.com/office-addins-blog/2015/06/24/calculate-time-excel/

OR switch to 1904 date system, or always make sure date and time are in the relevant cells

 

[Tom.Jones]

Hi,

one way

=IF(OR(P2="",O2=""),"",(P2>O2)+O2-P2)

 

[dispatchergirl911]

That took care of it!, thank you