i don't know much about VBA so i need your help please.
i need running time in one of the cell based on following condition:
in cell A1 user will report problem
in cell B1 is "time issue reported" and time will automatically come as soon as user enter problem in A1
after getting above time, now in cell F1 it will start timer starting from: 00 - 00:00:00 (dd - hh:mm:ss)
in cell C1 is "time when actual problem started" where user will manually input time.
it is 100% sure that user might noticed problem after 5 or 10 or 30 minutes. lets say user noticed it after 10 min - since timer was started from 00:00:00 and C1 was updated 10 min after the actual problem, then timer in F1 should updated like 00:10:00 and keep running until user enter the time problem was solved. then timer should stop and show in D1 for total time for the problem.
thnx
i need running time in one of the cell based on following condition:
in cell A1 user will report problem
in cell B1 is "time issue reported" and time will automatically come as soon as user enter problem in A1
after getting above time, now in cell F1 it will start timer starting from: 00 - 00:00:00 (dd - hh:mm:ss)
in cell C1 is "time when actual problem started" where user will manually input time.
it is 100% sure that user might noticed problem after 5 or 10 or 30 minutes. lets say user noticed it after 10 min - since timer was started from 00:00:00 and C1 was updated 10 min after the actual problem, then timer in F1 should updated like 00:10:00 and keep running until user enter the time problem was solved. then timer should stop and show in D1 for total time for the problem.
thnx
