Wimpie
Board Regular
- Joined
- Aug 12, 2008
- Messages
- 210
Good day
Please assist with the below
In Column G in need the following:
If the Saturdays worked count is between 0 and 2 Column G must have nothing in it
If the Saturdays worked count is 3 I need Column G to display 04:00 hours in the [HH]:mm format
If the Saturdays worked count is 4 I need Column G to display 08:00 hours in the [HH]:mm format
If the Saturdays worked count is 5 I need Column G to display 12:00 hours in the [HH]:mm format
<tbody>
</tbody>
Please assist with the below
In Column G in need the following:
If the Saturdays worked count is between 0 and 2 Column G must have nothing in it
If the Saturdays worked count is 3 I need Column G to display 04:00 hours in the [HH]:mm format
If the Saturdays worked count is 4 I need Column G to display 08:00 hours in the [HH]:mm format
If the Saturdays worked count is 5 I need Column G to display 12:00 hours in the [HH]:mm format
F | G |
Saturday worked count | Saturday hours |
3 |
<tbody>
</tbody>
Last edited: