Hello,

Could someone please advise om how to add the following formula into my
spreadsheet which NickHK kindly gave me:

Here is my original query:

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.


Here is NickHK's solution:

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

I do not know how to enter in the formula, so any help here would be greatly
appreciated,

Kind regards,

Chris.

Chris,

Try this:
In H1 enter: =G1-F1

then in I1 (you may have to insert a column to make room for this) enter
=DAY(H1) & " days " & HOUR(H1) & " hours " & MINUTE(H1) & " minutes"

You can then hide col G if you wish, since your desired info will be in
column I now.

"Chris Hankin" wrote:

Hello,

Could someone please advise om how to add the following formula into my
spreadsheet which NickHK kindly gave me:

Here is my original query:

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.


Here is NickHK's solution:

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

I do not know how to enter in the formula, so any help here would be greatly
appreciated,

Kind regards,

Chris.

Thankyou Gocush - your help is 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!