sum of timesheet

N

nidabland

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,
 
F

Fred Smith

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy a formula using Vlookup 2
Time calculations for Scheduled vs Actual Employee Time and Wages 4
Time calculations for Scheduled vs Actual Employee Time and Wages 2
Time calculations for Scheduled Time vs. Actual Time Worked 1
if statement 2
Real-time sorting 11
Subtraction formula with Text error 7
Mandatory and optional formula 5

Top