| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Time for IFERROR?
I am calculating the time between two dates. In the formula, I account for
the dates being reversed by a conditional. Sometimes the data points are "N/A" if there shouldn't be a date. The formula below returns a "#VALUE!" error. Is there a way using IFERROR to return a blank? =IF((('Raw Data'!F3-'Raw Data'!E3)/$J$1)0,('Raw Data'!F3-'Raw Data'!E3)/$J$1,"") Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Subtracting Dates to get total time work time excluding weekends | Excel Discussion (Misc queries) | |||
| Converting date/time serial values to cumulative time totals... | Excel Discussion (Misc queries) | |||
| verify use of TIME Function, Find Quantity Level compare to time-d | Excel Discussion (Misc queries) | |||
| template or formula for start time -finish time -total hours ple | New Users to Excel | |||
| Calculating days & time left from start date/time to end date/time | Excel Worksheet Functions | |||
Threaded Mode
