| 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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do I calculate a week days hours with the 24hour clock
You should be able to use this formula to calculate the number of premium
hours... =24*IF(J2<I2,1,J2)-24*I2 -- Rick (MVP - Excel) "F. Learning" wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do I calculate a week days hours with the 24hour clock
Many Thanks Rick works perfectly for Sunday but could you help me with the
Sunday hours included in Saturday rosters. e.g. start 20.00 Sat finish 08.00 Sun Have tried myself but cannot get it. Many Thanks again "Rick Rothstein" wrote: You should be able to use this formula to calculate the number of premium hours... =24*IF(J2<I2,1,J2)-24*I2 -- Rick (MVP - Excel) "F. Learning" wrote in message ... 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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do I calculate a week days hours with the 24hour clock
Sorry, I missed the Saturday into Sunday part of your question. Give this
formula a try... =24*(IF(H2<G2,H2,H2-G2)+IF(J2<I2,1,J2)-I2) -- Rick (MVP - Excel) "F. Learning" wrote in message ... Many Thanks Rick works perfectly for Sunday but could you help me with the Sunday hours included in Saturday rosters. e.g. start 20.00 Sat finish 08.00 Sun Have tried myself but cannot get it. Many Thanks again "Rick Rothstein" wrote: You should be able to use this formula to calculate the number of premium hours... =24*IF(J2<I2,1,J2)-24*I2 -- Rick (MVP - Excel) "F. Learning" wrote in message ... 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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do I calculate a week days hours with the 24hour clock
On Sun, 28 Jun 2009 08:32:01 -0700, F. Learning
wrote: 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 Try examining these time based cells, and see if what you want is not in there. Feel free to use whatever segments you wish. They work set up as 24 hr format as well. To use the drop down list, you would merely have to make the 24 hr format entry changes there, but it looks like it is the kind of thing you are after. http://office.microsoft.com/en-us/te...060381033.aspx |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do I calculate a week days hours with the 24hour clock
Thanks again Rick
Only getting back to it now. This works perfectly so thanks again F "Rick Rothstein" wrote: Sorry, I missed the Saturday into Sunday part of your question. Give this formula a try... =24*(IF(H2<G2,H2,H2-G2)+IF(J2<I2,1,J2)-I2) -- Rick (MVP - Excel) "F. Learning" wrote in message ... Many Thanks Rick works perfectly for Sunday but could you help me with the Sunday hours included in Saturday rosters. e.g. start 20.00 Sat finish 08.00 Sun Have tried myself but cannot get it. Many Thanks again "Rick Rothstein" wrote: You should be able to use this formula to calculate the number of premium hours... =24*IF(J2<I2,1,J2)-24*I2 -- Rick (MVP - Excel) "F. Learning" wrote in message ... 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 |
| Reply |
| 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)
Linear Mode
