Excel97 Date and Time Help Please

[Chris Hankin]

Hello,

Could someone please help me with a simple formula for the following:

In my workbook in column F I have a start date in dd mmm yyyy hh:mm format.

In my workbook in column G I have a start date in dd mmm yyyy hh:mm format.

In my workbook in column H I have a start date in dd mmm yyyy hh:mm format.

I need the difference between columns G and F to be calculated in column H.

For example:

In column F there is a date/time of 15 Jan 2005 07:30 and in column G
there is a date/time of 22 Jan 2005 14:15

So in column H, the difference should be 7 days and 6 hours and 15 minutes.

I hope this makes sense - I am not very good at mathematics.

Any help is greatly appreciated.

Thanks,

Chris.

 

[NickHK]

Chris,
If H1=F1-G1
Then I1=Day(H1) & " days " & Hour(H1) & " hours " & Minute(H1) & " mintues"

NickHK

 

[Chris Hankin]

Thanks very much NickHK - very nice work - much appreciated.

Cheers,

Chris.

Live Long and Prosper