Hello. I want to calculate the time a production unit is in a position. The
operator should only have to enter "time in" and "time out". The formula
should automatically deduct non-work hours. For example from 6:00 to 8:00
would be 2 hours (very simple). But from 11:00 to 14:00 would be 2 hours
also because there is a lunch from 12:00 to 13:00. From 16:00 to 7:00 should
be 2 hours also because shift ends at 17:00 and begins again at 6:00. I
can't find an example to use for this. Please help if you can!
--
Thanks,
Mike