ExcelBanter - INT, MOD help

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - INT, MOD help (https://www.excelbanter.com/excel-discussion-misc-queries/104363-int-mod-help.html)

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(DATEDI F(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.

Richard wrote:

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(DATEDI F(B16,TODAY(),"Y"),K:L,2,0)))

--

Dave Peterson