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 here: 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!
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.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
