See if you have worksheet_change event code which may be running in a loop
because when you put in the time, you're changing the worksheet and this can
cause the event code to run again. If that's the case, precede the entry of
the time with
Application.EnableEvents = False
and turn it to true afterwards.
HTH
Bob Umlas

" wrote:

I have a macro that grabs the current time from a website and then brings it
into my worksheet. I put manual calculation on when I run this and it takes
less than a second. However, when I put the sheet back on auto calc, it
takes 53 seconds to recalculate. If i actually go into the worksheet, put it
on manual, type in the new time, and then put it back on auto it only takes 5
seconds to recalc. Any reason why there would be such a discrepency? I have
several user defined functions in the workbook, but they are being used by
either form of recalculation. Any help would be greatly appreciated.

Thanks

Adam Bush