INT, MOD help

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

This formula is what I'm using to lookup vacation days in A3 which has a half
day(4 hours). I'd like for it to read whatever is in Column L such as 4.5
(something like "4 days 4 hours")
=(IF(DATEDIF(B16,TODAY(),"Y")>11,20,VLOOKUP(DATEDIF(B16,TODAY(),"Y"),K:L,2,0)))
 
Maybe...

=IF(DATEDIF(B16,TODAY(),"Y")>11,20,
INT(VLOOKUP(DATEDIF(B16,TODAY(),"Y"),K:L,2,0))&" days "&
8*MOD(VLOOKUP(DATEDIF(B16,TODAY(),"Y"),K:L,2,0),1)& " hours")

(You didn't need those ()'s around the whole formula.
 
Back
Top