+ Reply to Thread
Results 1 to 2 of 2

Billable hours per year style question

  1. #1
    Registered User
    Join Date
    09-29-2009
    Location
    Deerfield,IL USA
    MS-Off Ver
    Excel 2007
    Posts
    1

    Question Billable hours per year style question

    If I may I'd like to ask for help on the Excel 2007 formula to calculate billable hours per year.

    The Data for the days worked per year is currently 245 as a pre calculated number

    I've got the data for average hours worked per day it the top row and percentage of billable hours per year in the row immediately below it.

    B30 is filled as by a formula 245 on a General Cell format

    B31 is filled as 8.5 on a General Cell format

    B32 is filled as 100 on a Percent format

    I'm just a little stuck at =(B31*B32)*B30 being simple or using for future entry error checkings sake : =(B31*B32)*((B26*52)-(B27+B28+B29))

  2. #2
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: Billable hours per year style question

    Hi,
    could you upload a sample with your data layout? So far, it is not clear what you have in B27 to B29, so it's hard to tell which is the better formula.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1