Since 35.25 isn't in a recognised hh:mm format, you need to do some data conversion before you can get the correct result. Try:


=INT(E4)/($D$3-(B4+C4))+MOD(E4,1)/($D$3-(B4+C4))/60

RAUSHANM: Your formula is logically the same as the original one posted by dglazer and gives exactly the same erroneous result.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]