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