1. Registered User
Join Date
Jul 2005
Posts
154

Hello All,

I was wondering if I can get some help on figuring out a formula to auto calculate couple of columns.

Let me explain..
I have 3 columns that I use but only fill out one of them.

1 Time Spent:
In this column I fill out number of hours/minutes that I have spent doing the miscellaneous work stuff.

2. Total Hours
this column is calculated using the formula =SUM(TimeSpent) (works great no problem)

3. Days
In this column I have another formula which rounds off the hours. =ROUNDUP((Hours/8),1) (Works great no problem)
***************************************
1. After Hours (YES or NO)

I would like to know what formula I can use that will output values in both Total Hours and Days columns based on the answer in After Hours column.

For Example:

Time Spent After Hours Total Hours Days
2 YES 2*1.5 =ROUNDUP((Total Hours/8),1)
4 NO =ROUNDUP((Total Hours/8),1)

Any help is greatly appreciated !!

2. www.gvee.co.uk
Join Date
Jan 2007
Location
UK
Posts
11,445
`=IF(AfterHours="YES", 1.5, 1) * RoundUp(Total Hours / 8, 1)`