Quote:
Originally Posted by dglazer
E4, should be hours and minutes, so 35 hours and 25 minutes
|
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.