Calculating how many hours somebody worked in a certain interval

[Alex.Mac]

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 !

[ELeGault]

Fun times when it is grave.

=IF(Start Time>End Time,("24:00"-Start Time)+End Time,End Time-Start Time)
That should do it, obviously replace Start time and End time with references to the cells that they are in