rush2rajen
Member
Hi Excel Gurus
Please find the attached file.
I had manually written the solution in yellow colour mark. I had tried several times to write a formula but it all went in vain.
For eg. On Sunday HK1,HK2,HK3 will work in Room No 1 for 120 mins each.
Similarly I want to write a formula which will give me a result for HK1, HK2, HK3 and in which Room they will work and for how many mins and on which days.
Request you to kindly help on this.
Thanks in Advance
Regards
Raj.
Please find the attached file.
I had manually written the solution in yellow colour mark. I had tried several times to write a formula but it all went in vain.
For eg. On Sunday HK1,HK2,HK3 will work in Room No 1 for 120 mins each.
Similarly I want to write a formula which will give me a result for HK1, HK2, HK3 and in which Room they will work and for how many mins and on which days.
Request you to kindly help on this.
Thanks in Advance
Regards
Raj.