C
Chris Hankin
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.
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.