| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do I calculate a week days hours with the 24hour clock
I have a 24 hour roster using the formula:=((H8-G8)+(H8<G8))*24 to calculate
the no. of hours worked within the 24 hour period. G bing Start time H being finish time etc. I now wish to identify the hours attibutable to a Sunday which is payable at a premium rate. Sat Shift Sun Shift Start Finish Start Finish Cell G H I J Example: 20:00 08:00 in Saturday has 8 Hours premium 08:00 20:00 in Sunday has 12 Hours premium 20:00 08:00 in Sunday ending Monday has 4 Hours premium Is this possible? Any help should be appreciated as I am new to this Thanking you |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculate flying times using 24hour clock and 0000 general format | Excel Worksheet Functions | |||
| How to Subtract times on 24hour clock and avoid error message in . | Excel Worksheet Functions | |||
| how to chart data spread over 24 hours a day and 7 days a week? | Charts and Charting in Excel | |||
| Calculate Hours and overtime by week | Excel Worksheet Functions | |||
| How do I calculate the week day hours between 2 days | Excel Discussion (Misc queries) | |||
![F. Learning[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
