kimberly090
Board Regular
- Joined
- May 22, 2014
- Messages
- 99
Hi,
I have a complicate excel formatting to do but I have no idea where should start first.
There are few criteria that need to meet.
1. When cell value in F3 and H3 is filled, the time at cell N4 should auto add 3 hour based on the time on N3.
2. If system time is exceed then the time value on N4 and the value in F4 and H4 is still empty, it will trigger a message or format highlighting to inform user that the time is over.
3. If there is new bath being created at column B, the time at column N will stop adding the time and just left blank for user to key in the new time.
Hope my explanation is clear. Thank you.
I have a complicate excel formatting to do but I have no idea where should start first.
There are few criteria that need to meet.
1. When cell value in F3 and H3 is filled, the time at cell N4 should auto add 3 hour based on the time on N3.
2. If system time is exceed then the time value on N4 and the value in F4 and H4 is still empty, it will trigger a message or format highlighting to inform user that the time is over.
3. If there is new bath being created at column B, the time at column N will stop adding the time and just left blank for user to key in the new time.
Hope my explanation is clear. Thank you.
