Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2005
    Provided Answers: 1

    Unanswered: Formula Assistance needed

    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)
    Recently I have added 1 additional column.
    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)

    Spreadsheet attached

    Any help is greatly appreciated !!
    Attached Files Attached Files

  2. #2
    Join Date
    Jan 2007
    Provided Answers: 12
    Something like this?
    =IF(AfterHours="YES", 1.5, 1) * RoundUp(Total Hours / 8, 1)
    Home | Blog

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts