number_formaing

[Ravindra]

Dear All,

Please help me as per give details-


H I

13 FROM TO

14 08:30 08:50

=I14-H14


TOTAL MINUTE ==(HOUR(I15)*60)+MINUTE(I15)=20


unit(specific accoring project)=I16/I15=1.3333333


but accoring project need if unit exceed by integer than it would be added+1 integer,

as above i got unit 1.3333333 than it should be 2 since it's in fractional format.

So what logic should be that automatic unit returs complete integer value

 

[Faseeh]

Hi Ravindra,


Try enclosing your TOTAL MIN formula in:

=ROUNDUP(UrFormula,0)

Hope that works,


Faseeh