Pat wrote:
I wish to do the following:

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!


Where 13,5 is 1:30 pm 16,25 is 4:14 pm etc...

I have answered your original thread with a formula that will work if you
enter the times as times. You should be able to change it to accommodate
your format of data entry.