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!
-
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...- Ted1
- Post #4
- Forum: Microsoft: Office
-
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...- Ted1
- Post #2
- Forum: Microsoft: Office
-
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...- Ted1
- Thread
- Replies: 1
- Forum: Microsoft: Office
