I've entered this formula in cell b4, =IF(a4>TIMEVALUE("40:00:00"), a4-TIMEVALUE("40:00:00"), 0) to pull only the overtime hours out of the total hours worked in a week (44:34) from cell a4. Now my question is, if the total hours worked in cell a4 is LESS than 40:00, this formula should put a "0" in the cell b4, right? Because I tested it by putting in 32:55 in cell a4 and got back a value of 16:55. Keep in mind these are formatted as [h]:mm.
Last edited by readingmommy; 02-15-2012 at 10:32 AM.
If you specify more than 24 hours the TIMEVALUE (and TIME) functions only return the remainder part once divided by 24 so 40 hours will only return 16 hours.
Try: =IF(A4>(1/24)*40, A4-(1/24)*40, 0)
Dom
"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."
Use code tags when posting your VBA code: [code] Your code here [/code]
Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
Thank you! That work marvelously!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
readingmommy 
Register To Reply
Bookmarks