Hi Art

Sub test()
Dim t As Date, tt As Date
t = Now
'Your code
tt = Now
MsgBox Format((tt - t), "hh:mm:ss")
End Sub
--


XL2003
Regards

William
willwest22@yahoo.com


"Art" <Art@discussions.microsoft.com> wrote in message
news:EAEA51AD-1838-4725-9E7D-48EF22FF1B66@microsoft.com...
> Need Help..
>
> I would like to subtract the end time(hh:mm:ss) from the start
> time(hh:mm:ss) to get the duration (HH:MM:SS) of how long a job took to
> process.
>
> Thanks.
>