Hi,
Can some one help me in this task. I have attached the sheet. Where i need to find the overlapping timings between the two dates.
Ex: if second dates are with in first dates or first time interval then second dates should be marked as "0". If we see any difference between dates and time then we have to mention the time difference.
I have done with large formula.. But i need the same thing with short formula...
Thanks
Rajsha
Can some one help me in this task. I have attached the sheet. Where i need to find the overlapping timings between the two dates.
Ex: if second dates are with in first dates or first time interval then second dates should be marked as "0". If we see any difference between dates and time then we have to mention the time difference.
I have done with large formula.. But i need the same thing with short formula...
Thanks
Rajsha