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