Difference between starting time and ending time

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi

I have used formula '=TEXT(2003-11-15 17:45-2003-11-17 21:31; dd:hh:mm:ss")' to calculate the difference between two date and times in the format dd:hh:mm:ss. I would however like to add the result of all these calculations, but can't find a formula that gives me that information

Does anyone know how to do it?
 
Why not just subtract the dates from each other and format the result cell
as Custom Format dd:hh:mm:ss rather than use thge TEXT function? You can
then add them easily.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

DrValium said:
Hi,

I have used formula '=TEXT(2003-11-15 17:45-2003-11-17 21:31;
Click to expand...
dd:hh:mm:ss")' to calculate the difference between two date and times in the
format dd:hh:mm:ss. I would however like to add the result of all these
calculations, but can't find a formula that gives me that information.
 
Back
Top