software

How can I, just by inserting work period eg 8 16, afterwards in 2 cells see
all hours between 18 and 22 and hours between 22 and 5:15? Eg as written he
working time evening hours night hours
Patricia 12 20 2 0
Maria 16 24 4 2
-Where I only have to write the working time and excel calculates the
rest... I'm really having difficulties. Thanks!

Pat wrote:
gt; How can I, just by inserting work period eg 8 16, afterwards in 2
gt; cells see all hours between 18 and 22 and hours between 22 and 5:15?
gt; Eg as written he working time evening hours night
gt; hours
gt; Patricia 12 20 2 0
gt; Maria 16 24 4 2
gt; -Where I only have to write the working time and excel calculates the
gt; rest... I'm really having difficulties. Thanks!

if 12=12:00 and 24=midnight, how do you plan on entering minutes?
Pat wrote:
gt; How can I, just by inserting work period eg 8 16, afterwards in 2
gt; cells see all hours between 18 and 22 and hours between 22 and 5:15?
gt; Eg as written he working time evening hours night
gt; hours
gt; Patricia 12 20 2 0
gt; Maria 16 24 4 2
gt; -Where I only have to write the working time and excel calculates the
gt; rest... I'm really having difficulties. Thanks!

Assuming that you enter the times as

12:00 20:00
16:00 00:00

Columns A amp; B, then these formulas should hopefully do what you want:
For evening hours:
=IF((MIN(B2,TIME(22,0,0))-MAX(TIME(18,0,0),A2))*24gt;0,(MIN(B2,TIME(22,0,0))-MAX(TIME(18,0,0),A2))*24,0)

For night hours:
=IF((MIN(IF(B2lt;=TIME(5,15,0),B2 1,B2),1 TIME(5,15, 0))-MAX(TIME(22,0,0),A2))*24gt;0,(MIN(IF(B2lt;=TIME(5,15,0 ),B2 1,B2),1 TIME(5,15,0))-MAX(TIME(22,0,0),A2))*24,0)