For periods less than a month, Excel can do this automatically without the need for macros, via a simple subtraction formula and a custom cell format (d h:mm:ss). For greater periods, a different formula can be used.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]