Pat wrote:
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!

if 12=12:00 and 24=midnight, how do you plan on entering minutes?