View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
jimar jimar is offline
external usenet poster
 
Posts: 25
Default Hours & minutes calculation

I have inherited a workbook from a previous employee and cannot understand
the following formula.

=IF(AND(((AA22-INT(AA22))=0.59),((AA22-INT(AA22))<=0.61)),
(AA22+0.4),AA22)

The worksheet is used to work out hours&mins of a working day and in this
case cell AA is 2hrs 59 mins and the above formula returns 2.99. Can someone
explain?
Thanks