Results 1 to 9 of 9

VLOOKUP to reference allowed break times

Threaded View

  1. #1
    Registered User
    Join Date
    03-29-2010
    Location
    Houston
    MS-Off Ver
    Excel 2007
    Posts
    57

    VLOOKUP to reference allowed break times

    I need some formula for columns M &N rows 83 - 119 to calculate the appropriate off or break time of employees. this formula needs to go into E103:E109 & K103:K109.


    i tried using

    =VLOOKUP(MINUTE($J$48)+HOUR($e103)*60,$M$84:$N$119,2,1)

    but it didnt work


    I need all kinds of help all around, anything you have will be appreciated.
    Attached Files Attached Files
    Last edited by Kmac; 04-02-2010 at 02:45 AM.

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