Need some help generating a formula for a deduction

[NathanB]

Hello all!

First post, here. I have a working knowledge of Excel, but not a lot beyond that (i.e. very little experience in writing formulas). Here's my situation:

I'm woking on modifying a timesheet record for my company. On the spreadshhet we record our hours for the day at up to three locations and the total hours for the day are added from the three sectors and shown at the far right of the row. That's the simple part. Here's what I want to do with this. Sometimes we take a 1/2 hr unpaid luch and sometimes we don't. I'd like to add a "lunch" column that the crew leaders can use to show if a lunch was taken or not. Maybe just typing in either a "Y" or "N" to show this. If the crew leader types in a "Y" in this column, I'd like there to be a deduction of - 0.5 hour from the total hours for the day sector. I'm sure there is a way to do this or some similar someone has done in the past. How can I do this?

Any help is appreciated. Thanks!

 

[VoG]

Hi. Something like this perhaps

Excel Workbook
	A	B	C	D	E
1	Loc A	Loc B	Loc C	Lunch	Total
2	02:30	03:15	02:45	Y	08:00
Sheet7

 

[danzon]

=IF(D1="y",SUM(A1:C1)-0.5,SUM(A1:C1))


...edit: wait a sec...just occured to me...are you wanting to potentially reduce EACH sector by 0.5 ? rather than just the total...?

so you need the possibility to enter a Y or N for each of the three sectors ?

 

[NathanB]

No, I just needed to deduct -0.5 from the total hours for the day.

Thanks for the quick replies! This has taken care of my question!