ExcelBanter - Hours & Days

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

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

- - Hours & Days (https://www.excelbanter.com/excel-discussion-misc-queries/191129-hours-days.html)

bluesifi

Hours & Days

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

Sean Timmons

Hours & Days

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.

"bluesifi" wrote:

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

All times are GMT +1. The time now is 02:17 AM.