Thread: Need a function that calculates time between 2 dates
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
MartinW
 
Posts: n/a
Default Need a function that calculates time between 2 dates
Hi Rawis,

In A3 put =A2-A1
And format cell as custom d:hh:mm for 3:12:00 or
dd:hh:mm for 03:12:00

HTH
Martin


Reply With QuoteReply With Quote