Day Calculation Error
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
|