separate time in 2 shifts

[DEAN HOWES]

Peter, what a result!, you say its not pretty, but I say pretty smart. Now that I see the formula in practice I can pull it apart at my own pace to learn what is going on. Thanks to all the community for help with this one.

As a footnote, I'm pretty surprised by the lack of examples out there on this time sheet problem as its now becoming a pretty standard method of working in the UK, although for the most part the shifts wont be quite so long. For anyone thinking I'm running a business with unacceptable working times, I should add that these examples are for standby time only where people are available to work and not actually doing anything.
Once again Thanks to all!

 

[Peter Bartholomew]

… a business with unacceptable working times

Thanks for the clarification . I must admit, I was beginning to wonder …

 

[Peter Bartholomew]

Hi DEAN
You might like to look at the attached 'demo' workbook.

I am not suggesting you adopt the programming style (to the best of my knowledge no one else on this forum works the way I do). Despite that, you may find some ideas that you could use or that might clarify some of the features you already have in your workbook.

General discussion. I suspect that the methods I use take several times as long to develop than traditional 'click and pray' workbooks based upon the spreadsheet defaults of direct (single-cell, relative) references. That might raise the spectre of lost productivity!
On the other hand, the number of hours spent developing formulas can finish up as an almost insignificant part of the overall time spent checking, error tracking, debugging, maintaining, documenting, and enhancing functionality. There is some element of 'invest to save'.

 

[LearningExcel88]

Dear all,

I am so happy I found this post, as I am seeking for a similar solution.
Is it possible to adjust your solutions to a 3-shift model? I am not able to adjust the median formula accordingly to get the results...
Thanks a lot in advance!

BR

 

[vletm]

LearningExcel88
Please reread Forum Rules:

Site Rules - New Users - Please Read

Hi all, Welcome to the Chandoo.org Forums. Posting Rules & Etiquette The Chandoo.org Forums is a collaborative and happy place to learn and expand your Excel knowledge. The Chandoo.org Forums consist of several Sub-Forums based on the type of question/area of Excel you are interested in...

chandoo.org

How to get the Best Results at Chandoo.org
Start a new post every time you ask a question, even if the theme is similar.
The original author may continue asking questions whilst the post is in progress and of course if you are answering questions you may need to ask questions of the initial poster.
This is already few year old thread and
this is closed now.