Sorry....my ref to I7 should have been to cell A1.

B1: =TEXT(A1/24,"[h] \h\r\s mm \m\i\n\u\t\e\s")

I hope that helps.
***********
Regards,
Ron

XL2002, WinXP


"Ron Coderre" wrote:

Try something like this:

With
A1: 47.45


B1: =TEXT(I7/24,"[h] \h\r\s mm \m\i\n\u\t\e\s")

or....
Just give A1 a Custom Number Format

Select A1
From the Excel main menu:
<format<cells<number tab
Category: Custom
Type: [h] "hrs" mm "minutes"
Click the [OK] button

Is that something you can work with?
Does that help?
***********
Regards,
Ron

XL2002, WinXP


"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