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
|