View Single Post
  #4   Report Post  
Jason Morin
 
Posts: n/a
Default

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
.