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

=ROUND(A2-A1,0)&" days and "&TEXT(A2-A1,"h:mm:ss")

Or if it is less than one month, you can just subtract them (=A2-A1) and use
a custom format of

d "days and" h:mm

They both look like this
25 days and 1:20:27