Thank you, Biff! Would that everyone herein possess such perspicacity!
(If any doubt my sincerity, please bear in mind I created this acct with the sole purpose of expressing my gratitude. Seriously.)
Quote:
Originally Posted by T. Valko
"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.
|
Similar Threads
Hybrid Mode
