Hi All .....
How do I get C4 to add the contents of A1, A2 and A3 when the time is between 11:00:00 and 11:00:10 and then hold the value after 11:00:10?
I've tried using LEFT,RIGHT and MID NOW() but just can't get it to work. (not the sum part, the time part)
Regards .... G-fer
How do I get C4 to add the contents of A1, A2 and A3 when the time is between 11:00:00 and 11:00:10 and then hold the value after 11:00:10?
I've tried using LEFT,RIGHT and MID NOW() but just can't get it to work. (not the sum part, the time part)
Regards .... G-fer