| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF formula for time
I have two columns
Time taken to complete work Completed within 24hrs 23:00 Yes 25:00 No I want to know if anything has gone over a 24hr time limit before I had it calculate =IF(C324,"NO","YES") so if C3 was 25:00 it would give me a NO or 23:00 a YES right now it gives me all YES even if it is over 24 Do I have to change the format of =IF cell or input a new formula Thanks for your time |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Time formula (difference of predicted and actual time) | Excel Discussion (Misc queries) | |||
| formula for converting military time to standard time, etc | Excel Discussion (Misc queries) | |||
| 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
