The subject and body of your post don't jive. If A1
contains hours, then to convert to days / hours / minutes:
=INT(A1/24)&" days "&INT(MOD(A1/24,1)*24)&" hrs "&ROUND
(MOD(MOD(A1/24,1)*24,1)*60,0)&" min"
HTH
Jason
Atlanta, GA
-----Original Message-----
Guys.... how can I make cell A1 (which as 159.25 hours)
say 6 hours and so
many mintues?
Thanks for you help
Tony
.
|