View Single Post
  #2   Report Post  
Bob Phillips
 
Posts: n/a
Default

Tony,

I assume that you mean 6 days etc?

=A1/24

and format as d\d hh:mm:ss

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Tony" wrote in 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