Dear All. Please kindly advise what formula is used with my situation?
My company start working on 08:30 to 12:00. And start work again on 13:00 to 17:30.
Alex is over 1 min and Jonh is 5 min. I would like to have a formula at column F.
<tbody>
</tbody>Many many thanks
My company start working on 08:30 to 12:00. And start work again on 13:00 to 17:30.
Alex is over 1 min and Jonh is 5 min. I would like to have a formula at column F.
A | B | C | D | E | F | |
1 | Clock In | Clock Out | Clock In | Clock Out | ||
2 | Alex | 8:31 | 12:01 | 12:59 | 17:31 | 1 |
3 | Jonh | 8:29 | 11:55 | 12:50 | 17:30 | 5 |
4 |
<tbody>
</tbody>