Hi,

I have no idea what you mean by a formula that will work outside Excel but
this will work in Excel

=((B1-A1)-C1)*24

Mike

"pol" wrote:

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