Hours & Days

  • Thread starter Thread starter bluesifi
  • Start date Start date
B

bluesifi

Hi

If in a formula you are working out if something is greater 2 hours, you pur
2/24. How do you express it is you was 1 day or 2 days.

ie =IF(AND(N2-E2<2/24,D2="HIGH"),"YES",IF(AND(N2-E2< ?????,D2="MEDIUM")

I wand ????? to equal 2 days.

Joanne
 
1 day is 1. 2 days is 2. 2 hours is 2/24th's of 1. So, you would enter 2 to
indicate 2 days.
 
Back
Top