Something like:
=INT(A1)&" hours and "&INT(MOD(A1,1)*100)&" minutes"
with 47.45 in A1

checkQ wrote:

Hi,
Does anyone knows a formula to convert the decimal time 47.75 to text in
order to read 47 hrs and 45 minutes?
Thanx

--

Dave Peterson