| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to use time in an IF formula
Good morning.
I'm having trouble using time (minutes and seconds) in an IF formula. I'm trying to assign a rating to four time thresholds. My rating and thresholds are as follows... "EE" <0:45 sec "MA" 0:45-1:00 "MM" 1:01-1:30 "DNM" 1:31 For example, if cell P7 is 0:42 then cell Q7 would be assigned a rating of "EE". If P7 is 1:31 then "DNM". Please tell me what my IF formula should be. I have tried everything and nothing has worked so far. I appreciate your help. Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Time formula returns night time by mistake | Excel Discussion (Misc queries) | |||
| Calculating Time with Date/Time checking in formula | Excel Worksheet Functions | |||
| convert from percentage of time to time using complex formula in . | Excel Worksheet Functions | |||
| Formula to find Stop Time from Start Time and Total Minutes | Excel Worksheet Functions | |||
| template or formula for start time -finish time -total hours ple | New Users to Excel | |||
Threaded Mode
