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.