Thanks a lot for your help it's working fine.

If you have some time can you explain me this folmula and how it is working?
It will helps us all out.


"Ron Rosenfeld" wrote:


Now with more information as to your requirements, try this:

=1+TEXT(A1,"00\:00")-(MID(B1,4,5)+5)/24

--ron
.