Excel97 Date and Time Help Please
 

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.

Excel97 Date and Time Help Please
 

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

NickHK

"Chris Hankin" wrote in message
...
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.

Excel97 Date and Time Help Please
 

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

Cheers,

Chris.

Live Long and Prosper :)

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!