Forum Discussion
Calculate Total Hours Worked / Night Differential of Multiple Personnel having Different Shifts
As I noted in the workbook, that solution requires Excel 365 or Excel for the web.
Microsoft ended mainstream support for Excel 2007 in October 2012 (and ended extended support in October 2017). Consider getting a newer version, or switching to an alternative product; more than one are free.
The new attached workbook contains alternative formulas. These formulas are not as easy to understand. Microsoft's online documentation no longer identifies what functions were available in Excel 2007, so I am guessing that the functions in these formulas were all supported in Excel 2007.
Still, you could be explicit in how Night Differential is to be calculated. My notes in the new workbook on this calculation are slightly different. (Other formula notes are also different, as different functions were used.)
From what you've said in response to my questions, I don't think that you need formulas at this time. What you need is a clear definition of the purpose for which you're storing each of these pieces of information and how they're to be computed (IF, that is, computation is what you want. As it is, you're entering manually numbers that don't agree with the specific data elements, for whatever reason ("management approval needed" might be one of them, "routine entry" might be another). But whatever, until full AI is employed, AI that can read you mind and the mind of those who oversee this, I'm not the person to help; I'd want some better rules articulated so as to write reliable formulas. I wish I could, and if we were sitting down face-to-face I'd be asking a lot more probing questions, but we're not, so I can't. Best wishes.
By the way, you should remove that link because it's pretty clear you posted the spreadsheet with real names, not fake ones. Or go in and erase them and post a copy without any names. That's one of the rules of this forum.
