Show difference in 2 dates as hh:mm:ss

[CMeads1975]

Hi I have two dates, for arguments sake date1 and date2 i want to take one from the other and show as either dd hh mm ss or hh mm ss where hh may be greater than 24

Date1=01/10/10 14:24
Date2 =06/10/10 09:36

I want the answer 4 Days 19 Hours 12 Minutes or 111 hours 12 minutes

but when i do Expr1: Format([date2]-[date1],"hh:mm:ss") I get 19 Hours 12 minutes or if I do Expr1: Format([date2]-[date1],"dd:hh:mm:ss") I get 03:19:12:00

Any ideas?

Thanks

Carl.

 

[MStef]

Look at this threadhttp://www.access-programmers.co.uk/forums/showthread.php?t=199767