Hi all,

Please anybody can help me to write a general function that can be used in
excel as well as outside excel. I have the following information

opening time closing time breake Effective hrs
9.00 17.30 1.40 ?
8.30 16.40 1.50 ?
7.40 17.50 2.45 ?

I want to write a function to find effective hours. Pls help

With thanks

Polachan