On Tue, 18 Sep 2007 08:08:32 +0100, "David Biddulph" <groups [at]
biddulph.org.uk wrote:

=INT(A1) for the hours
=MOD(A1,1)*60 for the minutes.


That does not give what the OP requested:

OP 2.97-- 3hrs 37 min

DB 2.97-- 2hrs 58.2 min
--ron