convert time to text
 

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

convert time to text
 

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

convert time to text
 

try:

=LEFT(A1,2) & " hrs " & RIGHT(A1,2)*60/100 & " minutes"

--
Gary''s Student - gsnu200720


"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

convert time to text
 

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

convert time to text
 

One way:

A1: 47.75
A2: =TEXT(A1/24,"[h] ""hrs and ""mm"" minutes""")

In article ,
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

convert time to text
 

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

convert time to text
 

This will work, even if you have more or less than 2 digit hours and minutes

=MID(A1,1,FIND(".",A1,1)-1)&" hrs and "&MID(A1,FIND(".",A1,1)+1,99)&" mins"

Vaya con Dios,
Chuck, CABGx3



"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

convert time to text
 

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

convert time to text
 

Thanks for the resspose they worked perfectly

"CLR" wrote:

This will work, even if you have more or less than 2 digit hours and minutes

=MID(A1,1,FIND(".",A1,1)-1)&" hrs and "&MID(A1,FIND(".",A1,1)+1,99)&" mins"

Vaya con Dios,
Chuck, CABGx3



"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

convert time to text
 

Sorry, didn't read your post real well...........this one will convert the
..75 to 45 minutes............

=MID(A1,1,FIND(".",A1,1)-1)&" hrs and "&MID(A1,FIND(".",A1,1)+1,99)/100*60&"
mins"

Vaya con Dios,
Chuck, CABGx3



"CLR" wrote:

This will work, even if you have more or less than 2 digit hours and minutes

=MID(A1,1,FIND(".",A1,1)-1)&" hrs and "&MID(A1,FIND(".",A1,1)+1,99)&" mins"

Vaya con Dios,
Chuck, CABGx3



"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