Excel - IF Function Problem - Expert Solution

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
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
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.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.