Hi guys,
I don't really know how to solve a problem..
I have a table in which the working hours are calculated. For every worker in every day I have 2 cells: the time he started working (time formatted) and how many hours he worked. For example, Worker 1 started working at 20:00 and worked for 9 hours.
I would like to know how can I calculate in a single formula how many hours has Worker1 worked between 22:00 and 06:00 o'clock (because those are considered night hours and has to be pay with a bonus).
Thank you in advance for your help !
Bookmarks