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

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

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

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

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

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