On Mon, 17 Sep 2007 13:28:28 -0700, Dallas Colt
wrote:

How do I convert a cell showing 2.97 into 3 hours and 37 minutes and place 3
in one column and 37 in the other column...make sense???

A1: 2.97

If you have the ATP (analysis tool pak) installed:

=INT(DOLLARDE(A1,60)) -- 3
=MOD(DOLLARDE(A1,60),1)*60 -- 37

If you don't, then:

=INT(INT(A1)+MOD(A1,1)/0.6) -- 3
=MOD(INT(A1)+MOD(A1,1)/0.6,1)*60 -- 37



--ron