**Question description:**

*This user has given permission to use the problem statement for this blog.*

In my spread sheet, F5 shows 7:13. F6 is blank. F7 has the formula =IF(ISBLANK(F6),"",F5-F6). When I put 7:15 in F6, it shows 0:02 in F7. If I put 7:10 in F7 it shows ######. I need F7 to show negative or positive times

Solved by F. H. in 40 mins

This is the chat thread from the real Excelchat help session. It contains no private user information.

Excelchat Expert
12/11/2017 - 05:22

Hi

User
12/11/2017 - 05:22

Hello

Excelchat Expert
12/11/2017 - 05:22

can you upload your file

Excelchat Expert
12/11/2017 - 05:22

?

User
12/11/2017 - 05:22

no

Excelchat Expert
12/11/2017 - 05:22

ok

Excelchat Expert
12/11/2017 - 05:24

use somethign like this

Excelchat Expert
12/11/2017 - 05:24

=IF(B2-A2<0, "-" & TEXT(ABS(B2-A2),"hh:mm"), B2-A2)

User
12/11/2017 - 05:25

I also want to leave F7 blank until i add info in F6

Excelchat Expert
12/11/2017 - 05:26

in place of F5-F6

Excelchat Expert
12/11/2017 - 05:26

use above formula

Excelchat Expert
12/11/2017 - 05:28

did it worked?

User
12/11/2017 - 05:29

no

Excelchat Expert
12/11/2017 - 05:30

instead if this

Excelchat Expert
12/11/2017 - 05:30

=IF(ISBLANK(F6),"",F5-F6)

Excelchat Expert
12/11/2017 - 05:30

use this

Excelchat Expert
12/11/2017 - 05:31

=IF(ISBLANK(F6),"",=IF(F5-F6<0, "-" & TEXT(ABS(F5-F6),"hh:mm"), F5-F6))

Excelchat Expert
12/11/2017 - 05:32

=IF(ISBLANK(F6),"",IF(F5-F6<0, "-" & TEXT(ABS(F5-F6),"hh:mm"), F5-F6))

User
12/11/2017 - 05:34

does not work. left F7 blank.

Excelchat Expert
12/11/2017 - 05:35

can you share a sample file

User
12/11/2017 - 05:35

how do i do that

Excelchat Expert
12/11/2017 - 05:36

careta any dummy file

Excelchat Expert
12/11/2017 - 05:36

and put the data in there

Excelchat Expert
12/11/2017 - 05:36

in F6 aand F5

User
12/11/2017 - 05:38

don't know how to do that. there must be something i'm leaving out of my existing formula that can make it do a negative time

Excelchat Expert
12/11/2017 - 05:39

you can'thave a negative time

Excelchat Expert
12/11/2017 - 05:39

you have to use Abs

User
12/11/2017 - 05:40

yes you can. when i put a time in F6 that is less than the time i F5 it should be negative in

Excelchat Expert
12/11/2017 - 05:40

but in formula you can't

Excelchat Expert
12/11/2017 - 05:41

the above formula gives you a negative time

**This is the output file from the real Excelchat help session:**

*This is an example of the expert help you can get. It contains no private user information.*