Multiple Choice?

  • Thread starter Thread starter That's Confidential
  • Start date Start date
T

That's Confidential

Me again!

Don't know if this is at all possible, but I thought I would ask!

I am trying to make a spreadsheet which will calculate the hours which I
have worked, the hours which I shouldn have worked, my sick pay, holiday pay
and my short time.

I have set up the spreadsheet so that, in column C, I enter start time, and
column D the finish time. Cell E then automatically works out hours.

ie. C D E
10:00 18:00 08:00

However, what I would really like is for column E to represent "worked", F =
"holiday", G = "Sick" and H = "Short time." Once I have entered the start
time and finish time in cells C and D, I would like a multiple choice box
then to open to let me select which column the total should go into, and
then I would be able to select, for example, sick and then 08:00 will
automatically appear in "Sick" cell

ie. Start Finish Worked
Holidays Sick Short
10:00 18:00
08:00

Any suggestions anyone please?

Thanks once again! I owe you all a drink if I ever meet you!
 
Hi
one way:
1. In E1 use data validation:
- select the cell
- goto 'Data - Validation'
- choose 'List' and enter your allowed entries (e.g. "Worked", etc.)

2. Now you may use the following IF function. e.g. enter in F1 (if this
is your worked column
=IF(E1="Worked", D1-C1,"")
in G1 enter (if this is your sick column
=IF(E1="Sick", D1-C1,"")

etc.
 
Thanks all!

Frank has answered my query!

Frank Kabel said:
Hi
one way:
1. In E1 use data validation:
- select the cell
- goto 'Data - Validation'
- choose 'List' and enter your allowed entries (e.g. "Worked", etc.)

2. Now you may use the following IF function. e.g. enter in F1 (if this
is your worked column
=IF(E1="Worked", D1-C1,"")
in G1 enter (if this is your sick column
=IF(E1="Sick", D1-C1,"")

etc.
Click to expand...
 
Back
Top