| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Converting total number of hours (24 hours) into days | Excel Discussion (Misc queries) | |||
| Convert days in decimal to days:hours:minutes | Excel Worksheet Functions | |||
| Convert decimal days to Days,hours, minutes | Excel Worksheet Functions | |||
| Problem converting Hours to Days, Hours, Minutes | Excel Worksheet Functions | |||
| converting hours to days,hours,minutes | Excel Worksheet Functions | |||
Linear Mode
