Probably not the most efficient, but this works...

=(LEFT(A1,FIND(":",A1)-1)+INT(MID(A1,FIND(":",A1)+1,4)/60))
&" hours and "&MOD(MID(A1,FIND(":",A1)+1,4),60)&" minutes"

Rick


"Beep Beep" wrote in message
...
I have a spreadsheet that has hours and minutes manually inputed. Is there
a
formula that will convert the following: 38:90 (38 hours and 90 minutes)
to
39 hours and 30 minutes?