There is a schedule of duty in the attachement. Please if you could
solve our problem of document looking--- in the fields C8, D8, E8, F8
you can see 0:00 and there is a formula in these cells to calculate the
time if these cells were filled in with time data. I just can delete
this 0:00 values with deleting the formula, but it's not convinient to
work later and to put the formula again when there will be some changes
in the schedule. So How can I get rid of these 0:00 values not deleting
the formula. I.e. how to realize the condition when If the cells C6 and
C7 are empty so C8 should be empty as well, no 0:00. And If the cells
C6 and C7 are not empty like to compare G6 and G7 cells with time data,
so show the formula result in G8. How to put 2 functions within one
cell? As I see it should be something like
G8=IF(G7<G6;G7+1-G6;G7-G6) OR IF(G6 and G7=0;G8="")
But it looks like impossible to have 2 functions one from another
separatly.
Please help, how to delete 0:00 in case when 2 cells above are empty???


+-------------------------------------------------------------------+
|Filename: test.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4198 |
+-------------------------------------------------------------------+

--
Huawei
------------------------------------------------------------------------
Huawei's Profile: http://www.excelforum.com/member.php...o&userid=30306
View this thread: http://www.excelforum.com/showthread...hreadid=499703

In G8 try this.

=IF(AND(G6="",G7=""),"",IF(G7<G6,G7+1-G6,G7-G6))

Does that help?

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=499703

Steve, Unfortunately it says Formula Error. How can I do? Please help!
Andy


--
Huawei
------------------------------------------------------------------------
Huawei's Profile: http://www.excelforum.com/member.php...o&userid=30306
View this thread: http://www.excelforum.com/showthread...hreadid=499703

I just tried it again in your test sheet and it worked no problem. When
the formula error message comes up, click on Ok and the place where the
error is will highlight in your formula toolbar. It's probably missing
a character for instance, if you typed the formula in as

=IF(AND(G6="",G7""),"",IF(G7<G6,G7+1-G6,G7-G6))

It would give you an error because the G7"" is not valid, it needs the
= sign.

=IF(AND(G6="",G7=""),"",IF(G7<G6,G7+1-G6,G7-G6))

Double check for typos.

HTH

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=499703

Damn you're good, man! Beautiful! Flawless! Thanx a lot man! You are the
God, Steve! That's a real help! The only expression worked for me was
=IF(AND(G6="";G7="");"";IF(G7<G6;G7+1-G6;G7-G6))
not =IF(AND(G6="",G7=""),"",IF(G7<G6,G7+1-G6,G7-G6))
; and , signs look like different.
Have a good one bud! Thanx a lot again for help!
If you have any GSM mobile communication related issues feel free to
ask me! I know a lot about it, compared to Excel. =)
King regards,
Andy


--
Huawei
------------------------------------------------------------------------
Huawei's Profile: http://www.excelforum.com/member.php...o&userid=30306
View this thread: http://www.excelforum.com/showthread...hreadid=499703

Please if someone could help me, how to make a drop-down menu of months
in the schedule, and when you сhoose a specified month - day
columnes are added in the schedule automatically???
Thanx in advance!
Andy


--
Huawei
------------------------------------------------------------------------
Huawei's Profile: http://www.excelforum.com/member.php...o&userid=30306
View this thread: http://www.excelforum.com/showthread...hreadid=499703