Calculation of time: Negative number

See attached. Column AI will show me if the patient is roomed on time by subtracting Column H and D. If the patient is roomed early the data shows as ####. Can this show as a negative number? If not, any recommendations how to show this.

This is also happening for column AK as well.

Thanks for the help.

Shawn

You can change the formula in AI2 to this:

=IF(D2>H2,"-"&TEXT(D2-H2,"hh:mm:ss"),H2-D2)

then copy down. Make similar changes to the formula in AK2.

Hope this helps.

Pete