How to find blanks in a row of numbers in Excel?

Cesar Aracena
Cesar Aracena used Ask the Experts™
on
Hi guys,

I'm running MS Excel 2010 and I need to create a "program" to input working hours for employees but with a caveant. I need to separate the time in different shifts. For example, if an employee works his 8 hours and checks out and is called again several hours later (in the same day) to work 4 more -extra- hours, it is obvious that he worked 12 hours but not in 1 shift.

In this example, the employee would not earn some money as if he worked 12 hours straight but instead, he would earn money for other things (like working night time, etc.).

How can I do this?

Thanks in advance!
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Most Valuable Expert 2012
Top Expert 2012
Commented:
Why not keep track of hours worked by employee, by shift?

In the example you articulated, the employee would get 8 hours in the first shift, say Shift1, then 4 more hours after a break, in Shift 3.

The attached is a mock up to demonstrate a report for a 3 shift day, each 8 hours each.  Now, for each individual, the time can be reported by shift.  And, acccounting beyond that can do more than account for total hours, but formulas for overtime, working more than one shift, nights, etc..

See attached simple example, with two alternatives - and you can create others customized to your needs!  First, just record time worked by employee by shift, then you can reward accordingly.  Second, you can record time worked by hour (24 hour clock) if you have certain hours of the day that either are shorter than an 8 hour shift or span more than an 8 hour shift.

Dave
report-work-in-shifts-r1.xls
Cesar AracenaPHP Enthusiast

Author

Commented:
Hi Dave,

I've never thought about it this way becouse it is a 24 hours "on call" job but yes, employees have hours to work and the rest are extra hours so I could think of it as shifts.

Thanks for the tip. I will wait a little more to see if someone comes up with a VB option or something to find gaps as it would give me more flexibility but so far, your idea seems to be right.
Most Valuable Expert 2012
Top Expert 2012

Commented:
Can you advise if you had any difficulties with what was provided?  Which approach did you end up using?

Dave

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial