Difference between starting time and ending time

[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?

 

[Bob Phillips]

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)

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.

 

[Guest]

Thanks a million. It is always the easy solutions that fix the problems.