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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks