Hi Alistair:

Let us say yor starting time is in cell C4, and ending time is in cell D4,
then you can use the following ...

=D4-C4 ... and ude Custom Number Format [hh]:mm to get difference in Hours
and Minutes

However if you want the answer in Days, Hours, and Minutes then let us try ...

=INT(D4-C4)&" day "&TEXT(MOD(D4-C4,1),"hh:mm")




"Alistair" wrote:

I am using Excel 2003. I have a date and time, each in its own column. I
also have another date and time, each in its own column. I need to find the
exact elapsed time between the two date/time sets, and most of the time, the
elapsed time is over 24 hours. How do I write the formula to give me the
exact elapsed time?

Thank you for any help you can give.