Hours & Days

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
 
S

Sean Timmons

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.
 

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

Help with calculating time and a half - I've got straight time and double time. 4
Multiple IF statement not working 5
Look-up 5
Counting text 2
Complex Look-up 4
using if for multiple criteria 11
Changing Hours in working Days 6
converting working hours to days 2

Top