Need Help with the following Dates.
i have a a file but cannot attach i have copied the table below hope.
<colgroup><col><col span="2"><col><col><col span="3"><col span="2"></colgroup><tbody>
</tbody>Please Help
Thanks
i have a a file but cannot attach i have copied the table below hope.
A | B | C | D | E | F | G | H | I | J |
1 | Allocation time | last picked time | time and date needs to be ready | picked late ? | Allocated Late | ||||
2 | 16/11/2018 14:27 | 16/11/2018 15:00 | 16/11/2018 14:00 | "yes" by how long by, so in this case 1 hour show 01:00:00 in cell G3 and yes in F3 | Not Late | 00:27:00 | |||
3 | If F3= "yes" was Cell B3 and C3 within 1 hour of each other this case "yes" show time difference in cell K3 and "Not late" in cell J3 | ||||||||
if B3 is >1 and <5 hours against C3 show "late" in J3 and time difference in K3 | |||||||||
<colgroup><col><col span="2"><col><col><col span="3"><col span="2"></colgroup><tbody>
</tbody>
Thanks