| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
calulating a certain weekday hours within a 24 hour roster
I am new to excel formulae bar the basis and have prepared a spread sheet for
input to calculate shift hours worked. I now wish to identify Sunday hours as these are paid at a premium rate. For example a shift 8pm to 8am on sat/sun gives 4 hours premium a Sunday shift 8am to 8pm gives 12 hr premium a Sunday/Monday shift 8pm to 8am gives a 8 hour premium The input fields are only time in and time out. Rostered hours are calculated as Follows: =((H8-G8)+(H8<G8))*24. where H8 is the time finished(Sun or Mon) and G8 is the start time.(Sun) Is there anyway I can identify Sunday hours worked. Many Thanks |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
calulating a certain weekday hours within a 24 hour roster
Hi,
First there doesn't seem to be any way to identify the day of the week if all you input are the start and end times. Second, I don't follow the logic "a Sunday/Monday shift 8pm to 8am gives a 8 hour premium" -- If this helps, please click the Yes button. Cheers, Shane Devenshire "F. Learning" wrote: I am new to excel formulae bar the basis and have prepared a spread sheet for input to calculate shift hours worked. I now wish to identify Sunday hours as these are paid at a premium rate. For example a shift 8pm to 8am on sat/sun gives 4 hours premium a Sunday shift 8am to 8pm gives 12 hr premium a Sunday/Monday shift 8pm to 8am gives a 8 hour premium The input fields are only time in and time out. Rostered hours are calculated as Follows: =((H8-G8)+(H8<G8))*24. where H8 is the time finished(Sun or Mon) and G8 is the start time.(Sun) Is there anyway I can identify Sunday hours worked. Many Thanks |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
calulating a certain weekday hours within a 24 hour roster
Many Thanks for your reply. The Sunday/ Monday should have read 4 hrs premium. "Shane Devenshire" wrote: Hi, First there doesn't seem to be any way to identify the day of the week if all you input are the start and end times. Second, I don't follow the logic "a Sunday/Monday shift 8pm to 8am gives a 8 hour premium" -- If this helps, please click the Yes button. Cheers, Shane Devenshire "F. Learning" wrote: I am new to excel formulae bar the basis and have prepared a spread sheet for input to calculate shift hours worked. I now wish to identify Sunday hours as these are paid at a premium rate. For example a shift 8pm to 8am on sat/sun gives 4 hours premium a Sunday shift 8am to 8pm gives 12 hr premium a Sunday/Monday shift 8pm to 8am gives a 8 hour premium The input fields are only time in and time out. Rostered hours are calculated as Follows: =((H8-G8)+(H8<G8))*24. where H8 is the time finished(Sun or Mon) and G8 is the start time.(Sun) Is there anyway I can identify Sunday hours worked. Many Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change times to 24 hour and add 6 hours in strings | Excel Worksheet Functions | |||
| ROUND UP HOURS to the next quarter hour | Excel Discussion (Misc queries) | |||
| How do I add hours and minutes without 24 hour limit | Excel Worksheet Functions | |||
| Calulating hours, minutes and seconds | Excel Worksheet Functions | |||
| How can I add hours and minutes then multiply by cost per hour? | Excel Worksheet Functions | |||
Hybrid Mode
