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.