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!