If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
sum of timesheet
Let's say A1: 9 am
A2: 12 pm A3: 12:30 pm A4: 3 pm I need the total in A5 to calculate how many hours worked, but also if I write "off" in A1:A4, I need A5 to say "off", so basically I need either the total hours worked or the word "off" in A5. Is this possible? Thanks for any help, |
#2
|
|||
|
|||
sum of timesheet
Try
=IF(COUNTIF(A1:A4,"off")=4,"off",SUM(A1:A4)) -- HTH Bob "nidabland" wrote in message ... Let's say A1: 9 am A2: 12 pm A3: 12:30 pm A4: 3 pm I need the total in A5 to calculate how many hours worked, but also if I write "off" in A1:A4, I need A5 to say "off", so basically I need either the total hours worked or the word "off" in A5. Is this possible? Thanks for any help, |
#3
|
|||
|
|||
sum of timesheet
Is "off" in *every* cell of a1:a4, or *any* cell?
If every, try: =if(countif(a1:a4,"off")=4,"off",a2-a1+a4-a3) If any, change =4 to =1 Regards, Fred "nidabland" wrote in message ... Let's say A1: 9 am A2: 12 pm A3: 12:30 pm A4: 3 pm I need the total in A5 to calculate how many hours worked, but also if I write "off" in A1:A4, I need A5 to say "off", so basically I need either the total hours worked or the word "off" in A5. Is this possible? Thanks for any help, |
Thread Tools | |
Display Modes | |
|
|