+ Reply to Thread
Results 1 to 1 of 1

Creating calendar formula and calulating employee hours and billable hours

  1. #1
    Registered User
    Join Date
    05-02-2015
    Location
    Honolu
    MS-Off Ver
    2010
    Posts
    43

    Creating calendar formula and calulating employee hours and billable hours

    Need some assistance with the attached worksheet. I am trying to:

    Create a monthly calendar to be used each month and change months and days for each new month.
    Calculate the billable hours from the 1st to the 15th and the 16th to the end of the month for each venue.
    Calculate the hours in the adjoining cell next to each employee's name for hours worked from the 1st to the 15th and the 16th to the end of the month.

    Any and all help is appreciated!

    Attached is an example of what I am trying to do.
    Attached Files Attached Files
    Last edited by ktps; 05-08-2015 at 07:59 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Assistance in creating a calendar to track billable hours and emplyees
    By ktps in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-02-2015, 04:25 PM
  2. Help with formula for working out billable hours
    By rjrfoster in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 06-10-2014, 11:48 AM
  3. Subtracting Non-Billable Hours
    By mycon73 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-23-2010, 04:37 PM
  4. Tracking Hours from Employee Calendar
    By asirigu in forum Excel General
    Replies: 1
    Last Post: 06-26-2010, 03:10 AM
  5. [SOLVED] can excel be used to track billable hours
    By minitech in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-19-2005, 04:05 PM

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