Time Sheet Help

Hi,

 

I am putting togethere a time sheet and i want to include exception codes. Specifically staff can only work between 07:00 and 19:00 and they can also only work a maximum of ten hours. I would like to write a function that will indicate when the start and finish times fall outside the limits and also if the total time exceeds maximum hours. So if a member of staff inputs their start time as 06:00 i would like the a seperate cell to say “HRS” and similarly if the finish at 19:15 or if their total is over ten hours the same return to show in the exception code cell. Can anyone help?

By: Adrian V

Leave a Reply

Your email address will not be published. Required fields are marked *