Excel VBA Beginner problem in time calculations

Hi, Experts.

I'm looking for a excel vba time calculation solution for a small project. I want to subtract the estimated time of work completion of certain cells with a running local current time. I did manage to subtracted it from current local time in another cell but i want to stop the calculation when it reaches the estimated time of work completion.

For example

A = 23:00:00 (Current local time which is updated accordingly as system time every second)
B = 10:05:00 (Fixed estimated time for work completion in next day)
C = 9:55:00 (calculated result of time variation between A & B in C cells which keep changes according to the current local time with =MOD((BX-AX), 1)


Result of C is ok and keep changing accordingly with the current local time. But, i want to stop the calculation of C cells once the current time value (A) = (B) in C cells and stop it from recalculation with display of "00:00:00" once the calculation result reach to the fixed value of B. I know, its only possible with VBA. Pls, help me out.

Thanking you all in advance

Here's one option

Please Login or Register  to view this content.