The warranty on my fingers must have run out this morning,
because this afternoon they're just not working right.

The value in A1 should have been 47.75
.....like you posted (and I mis-typed as 47.45)

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


***********
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