View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
marie
 
Posts: n/a
Default Calculating days & time left from start date/time to end date/time

Hello experts,
What formula should I use to show # days left, including time (in hrs,
mins and sec's) from current date/time to a target end date/time?
For instance:

Start Date: Now()
End Date: December 31, 2005 5:00:00 PM

Your help is greatly appreciated.
Marie