Possible to capture negative time errors?

  • Thread starter Thread starter Android
  • Start date Start date
A

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.
 
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
 
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.
 
Thank you for the answers.

Android.

bj said:
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.
Click to expand...
 
Back
Top