Mention the Day NOT the date please

[Guest]

Hi everyone,

I would like to establish a plan, that displays, the number of hours per
day. In the first Cell A1, mention the day (for instance: "Saturday" and not
the date: 16 Sept. 06). The date will not be introduced in any cell, so
nowehre.

In other words:

A1: "Monday"
A2: "Time(In): Time of arrival at work
A3: "Time(Out): Time of departure from work
A4: How many hours at 100%
A5: How many hours at 130%
A6: How many hours at 160%
A7: How many hours at 200%"

Remark100: From 07:00 - 19:00 Heures a 100%
Remark130: If one works later than 19:00 and the total number of hours is
less than 8.
Remark160: If one works later than 19:00 and the total number oh hours is
greater than 8.
Remark200: All hours done during Saturday and Sunday, during the day or the
night are equally considered at 200%.

Thanks very much for helping me
Tom

 

[Bob Phillips]

A4: =(AND(A1<>"Saturday",A1<>"Sunday"))*(MIN((A3-A2)*24,12))
A5:
=(AND(A1<>"Saturday",A1<>"Sunday"))*(((A3-A2)*24-A4)*(A3-A2<=TIME(12,0,0)))*
130%
A6:
=(AND(A1<>"Saturday",A1<>"Sunday"))*(((A3-A2)*24-A4)*(A3-A2>TIME(12,0,0)))*1
60%
A7: =(OR(A1="Saturday",A1="Sunday"))*((A3-A2)*24)*200%

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)