Possible to capture negative time errors?

[Android]

In my worksheet, a summation of time differences can be negative at times
during the day. Is there a way to capture it and display a text (e.g.,
"-ve").?

Functions such as ISERROR, and ISERR do not seem to handle it.

Android.

 

[Jason Morin]

While you can use negative time in calculations, you're
right, you can't display the actual value. For display
purposes, try:

=IF(B1>=A1,TEXT(B1-A1,"[h]:mm:ss"),TEXT(A1-B1,"-
[h]:mm:ss"))

HTH
Jason
Atlanta, GA

 

[bj]

you can select the cells with the calculation and use
<format><Cells><Custom> and enter
#;"-ve";#
This will display the text when the cell is negative.

 

[Android]

Thank you for the answers.

Android.

you can select the cells with the calculation and use
<format><Cells><Custom> and enter
#;"-ve";#
This will display the text when the cell is negative.