Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Ted1
  • Order by date
  1. Ted1

    Calculate extra and lost time (negative time)

    Another method: Thinking further about your problem, if you wish to show negative times in an hh:mm format, I think it's possible to "fake" a correct result using the CONCATENATE, MID, TEXT AND INT functions. Let's assume that cell F5 shows the equivalent negative numeric time value (negative...
  2. Ted1

    Calculate extra and lost time (negative time)

    I'd suggest that you complete your third column to indicate net hours worked in hh:mm format but then work in hours and decimals of an hour to complete any further calculations (including subtracting your standard 8 hours). The conversion is done by multiplying your net hh:mm by 24 and placing...
  3. Ted1

    Using VLOOKUP with AVERAGE

    Is anyone able to help me? Put simply, I need to combine the VLOOKUP and AVERAGE(OFFSET(range)) functions into one cell formula. There's a couple of limitations: 1) The interrogating sheet is produced on a daily basis and uses the sheet's date as the key to locating the correct row and cell...

Part and Inventory Search

Back
Top