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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

more help on INT, MOD 3
Tweaking formula? 2
Help with formula 3
Help with formula? 1
lookup? Index? match? formula 4
Help with formula 5
help with formula 1
Calculate age with an end date 3

Back
Top