I missed the part where you are using dates in dd/mm/yyyy instead of
mm/dd/yyyy, but it looks like you got your solution.


--JP

On Jan 28, 9:56*am, Dilly wrote:
Thanks for below, however this comes back to the problems i experienced as
described in my original post with a start date of 08/06/2007 08:43 and a
finsh date of 21/11/2007 13:00 shows as 14 days 4 hours and 17 minutes, when
it should be 166 days 4 hours and 17 minutes



"JP" wrote:
Put your start date and time in A5 (for example) and end date/time in
B5.

Here's the formula:

=(IF(INT(B5)-INT(A5)<1,24*(MOD(B5,1)-MOD(A5,1)),((INT(B5)-
INT(A5))*24)+24*(MOD(B5,1)-MOD(A5,1))))/24

Format as Custom: d "days," h "hours," mm "minutes"

Seehttp://tinyurl.com/2wu8yafor more assistance.

HTH,
JP

On Jan 28, 9:22 am, Dilly wrote:
Many thanks for below, which works for that specific start and end date,
however when i have a start date of 07/11/2007 12:29 and finish time of
07/11/2007 15:00 it gives an error "#DIV/0!" value instead of 0 days 2 hours
31 mins ??
Nearly there though i think.

Once again your assistance is greatly appreciated- Hide quoted text -

- Show quoted text -