Posted to microsoft.public.excel.misc
|
|
Day Calculation Error
BRILLIANT, Thank you
"Rick Rothstein (MVP - VB)" wrote:
Actually I have the formating at custom dd "Days," hh" Hours"
If formatted General yes I get 63 days after rounding. Is there anyway to
re-format showing days and hours, but keep the "General" construct?
Maybe use this formula instead of the one you posted and leave the cell's
format as General.
=INT(NOW()-F32)&" Days, "&ROUND((NOW()-F32-INT(NOW()-F32))*24,0)&" Hours"
Rick
|