Thread: Calculate the difference between two times and show dd:hh:mm:ss
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Heera Heera is offline
external usenet poster
  
Posts: 98
Default Calculate the difference between two times and show dd:hh:mm:ss

Hi,

Select the cell right click go the "Format Cell..."

Select Numbers Tab
Category : Custom and type the below mentioned line.

dd "Days"-hh:mm

Regards

Heera
Reply With QuoteReply With Quote