Please help with enclosed schedule of duty

[Huawei]

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

 

[SteveG]

In G8 try this.

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

Does that help?

Steve

 

[Huawei]

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

 

[SteveG]

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

 

[Huawei]

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]

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

 

[SteveG]

Andy,

Do you want the columns inserted, populated with the correct weekday or
both the weekday and the date?


Steve

 

[Huawei]

No weekday, I need only the new columns to be inserted depending on the
lenght of the month, like when I choose Fabruary from the central
drop-down menu (I attached the file template february.zip, please check
it out) there must be 28 days inserted, when I choose March - there
must be 31 days (more columnes) inserted, for April - 30 days and so
on. As for schedule data like time of shifts - I will do it myself , no
need automatically to be filled in.


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

 

[Huawei]

Guys, can anyone help me with my case please

 

[Huawei]

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

I need only the new columns to be inserted depending on the lenght of
the month, like when I choose Fabruary from the central drop-down menu
(I attached the file template february.zip, please check it out) there
must be 28 days inserted, when I choose March - there must be 31 days
(more columnes) inserted, for April - 30 days and so on. As for
schedule data like time of shifts - I will do it myself , no need
automatically to be filled in.
Please if someone could help me, how to do it????


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

 

[SteveG]

Sorry for the delay in getting back to you. In and out of the office
this week. Unfortunately, this needs to be solved using VB of which I
am not very experienced with yet. I searched around but could not find
the exact solution for your needs. Maybe someone in the group with more
VB experience could offer a solution?

Thanks,

Steve