View Single Post
  #11   Report Post  
Posted to microsoft.public.excel.misc
Rick Rothstein \(MVP - VB\) Rick Rothstein \(MVP - VB\) is offline
external usenet poster
 
Posts: 2,202
Default 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