how do I calculate a week days hours with the 24hour clock

F

F. Learning

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
 
R

Rick Rothstein

You should be able to use this formula to calculate the number of premium
hours...

=24*IF(J2<I2,1,J2)-24*I2
 
F

F. Learning

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
 
R

Rick Rothstein

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)
 
W

WallyWallWhackr

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
Click to expand...

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/templates/TC300060381033.aspx
 
F

F. Learning

Thanks again Rick

Only getting back to it now. This works perfectly so thanks again

F
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to calculate difference between two date & time along with working hours and days 2
calulating a certain weekday hours within a 24 hour roster 2
How to calculate Premium Time 2
How can I work out how many hours I get premium rate? 4
how do i calculate hours worked in excel? 9
calulate working hours and minutes between 2 dates and times 9
How do I format a cell to calculate overnight Hours? 7
How do I calculate WORK-hours between end/start date 0

Top