Search results

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...

Peter, I will try your suggestion however which formula solution should I start with. Column G is a single time which will produce a negative therefore inappropriate time and as you say it is only helpful if there is no late clock on to go into the next day which unfortunately there could be.

VLETM, I can now see the output on 'TEST sheet' as you describe with all the relevant solutions. But I do not yet aspire to VBA, or even simple MACROS and I'm living in the world of formulas. My personal goal here is to learn how to achieve the outcome using formulas if that is at all possible...

VLETM,sorry #9 is not my sheet but contained almost identical problem but with manual solution for original poster. Im looking for formula to learn and automate my sheet

nope! missed the overnights completely. Check cell K8 answer should be 9 hours! same for all overnight shifts. I think this came out with the same as previously posted

Ill get back asap to update

:( Ha Ha, well that certainly explains why I cant find any to learn from!. Yep! I'm really interested in formula to extract the primary shift from the time worked. I laboured over fairly lengthy nested IF, AND formula without getting a reliable result across the sheet, especially when the time...

I've looked at #9. I cant find a reference or formula to show the shift parameters, which I ultimately wish to make dynamic. My shift sample is 09:00-18:00, but I will want to vary this from employee to employee. My goal is to track time at work for zero hours employees, and particularly those...

try again

I'm a newbie here. I have an almost identical issue but looking at your sheet I can't work out where your reference cells are for the shift start and end times. When I use the MEDIAN function suggested in the earlier post in my formula, I placed the shift times with an absolute cell ref, however...

Hi Finally needed to join a forum, Chandoo is the master so here goes. I'm in the UK, and trying to expand my mediocre knowledge of excel by searching out solutions to real problems. Many experts out there but I always seem to come back to the same 2-3 for help. Time now to see if anyone else...