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

I mean rounded. Rounded up would be

=ROUNDUP(14.58*60,0)/60/24


--

HTH

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


"Bob Phillips" wrote in message
...
If you need it rounded up, use

=ROUND(14.58*60,0)/60/24

--

HTH

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


wrote in message
...
Have a look in the help at how Excel handles times and dates

=14.58/24 formated as time

will return
2:34 PM (note: I belive time does not round up in Excel)

HTH
RES