View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
tom tom is offline
external usenet poster
 
Posts: 570
Default Mention the Day NOT the date please

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