=(INT(H20)+MOD(H20,1)/0.6)/24

Format as time.

Out of curiosity What are you doing?

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Dallas Colt" wrote in message
...
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???
--
Dallas