Dear all,
Case: Workers get payed more in a "overtime" period, assume from 00:00 till 06:00. Outside the payment is normal.
How to calculate the time within the normal working hours and the time in the "overtime" hours.
The attachement shows an example how to do this.
Last edited by rwgrietveld; 02-11-2010 at 03:54 AM.
Looking for great solutions but hate waiting?
Seach this Forum through Google
www.Google.com (e.g. +multiple +IF site:excelforum.com/excel-general/ )
www.Google.com (e.g. +fill +combobox site:excelforum.com/excel-programming/ )
Ave,
Ricardo
This will help you out..
...Marc
May God Bless You
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks