Damn! I forgot about the newsreader breaking lines at spaces. Here is the
same formula broken so that the newreader won't do that...
=INT(A1)&" hour"&IF(INT(A1)=1," ","s ")&MINUTE(A1/24)&
" minute"&IF(MINUTE(A1/24)=1,"","s")
Rick
"Rick Rothstein (MVP -
VB)" wrote in
message ...
Although perhaps this would be better...
=INT(A1)&" hour"&IF(INT(A1)=1," ","s ")&MINUTE(A1/24)&"
minute"&IF(MINUTE(A1/24)=1,"","s")
as it properly handles the "s" (plural/single) for when either/both the
hours and minutes are 1.
Rick
"Rick Rothstein (MVP - VB)" wrote in
message ...
I think you can do away with the two string function calls by doing
this...
=INT(A1)&" hours "&MINUTE(A1/24)&" minutes"
Rick
"T. Valko" wrote in message
...
"237 hours 50 minutes". if i can get with text, that would be great.
A1 = decimal value = 237.83
=INT(A1)&" hours "&RIGHT(TEXT(A1/24,"h:mm"),2)&" mins"
Returns: 237 hours 49 mins
--
Biff
Microsoft Excel MVP
"Josh" wrote in message
...
i want to display my vacation hours as as hours and minutes. right now
lets
say i have 237.83 displayed. i would like to find a way to display this
as
"237 hours 50 minutes". if i can get with text, that would be great. if
not,
i can work with that as well.