What do you mean by -ve time.?

Try the below
=ABS(A1-A2)
and format to [h]:mm

="-" & ABS(A1-A2)
to display as decimal hours -30:00 as -1.25

If this post helps click Yes
---------------
Jacob Skaria


"BadBoy" wrote:

Good morning all,

Perhaps you can help with a question;

When subtracting times using the time format, and the answer is a negative
time, the answer shows like this ##########

Cell A1 20:00 - Cell A2 50:00 = Cell A3 #######

Is the any way to fix this?

Thank you in advance.