+ Reply to Thread
Results 1 to 4 of 4

Automated Manhours Calculating Worksheet

  1. #1
    Registered User
    Join Date
    06-13-2013
    Location
    Singapore
    MS-Off Ver
    Excel 2010
    Posts
    6

    Automated Manhours Calculating Worksheet

    looking to construct a working spreadsheet to calculate the payable working hours based on day and time.
    i have the necessary values for it, but i need to translate it into reference tables for the excel to work on
    the excel will need to refer to tables based on weekdays,sat, sun/ph depending on the working date being keyed in or selected

    my idea is to create dropdown rows to select the date/time and the excel will refer to the reference to display the correct payable manhours

    have attached a sample of the values needed to be translated...

    http://imageshack.us/photo/my-images...nhrsample.jpg/

  2. #2
    Valued Forum Contributor
    Join Date
    10-26-2008
    Location
    Birmingham, UK
    MS-Off Ver
    All versions up to 2010
    Posts
    1,025

    Re: Automated Manhours Calculating Worksheet

    Hi
    Your idea makes sense but you need to advise the criteria based on the dropdown you wish to create then we can help you.
    Tony

  3. #3
    Registered User
    Join Date
    06-13-2013
    Location
    Singapore
    MS-Off Ver
    Excel 2010
    Posts
    6

    Re: Automated Manhours Calculating Worksheet

    hi,thanks for the offer
    im not sure what u mean by criteria but the dropdown will be the time in and time out values,as well as the day

  4. #4
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,443

    Re: Automated Manhours Calculating Worksheet

    Please post a sample sheet - Thx

+ 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