|
|
|
|
#1
04-06-2018, 12:53 PM
|
|||
|
|||
Hello, Thank you for the reply, you are correct for the first time I need to subtract the end and begin time, at each series beginning with 505. Regarding the PV column, the values of interest always occur within the same range of the 505 series, the one difference is up to 2 instances after the last 505 value is changed to 250, the PV value could still be above 490, so I would need to subtract that date value from the first date value where the PV was greater than 490. Hope that clears it up. 
|
|
| Tags |
| date subraction |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| subtract date and time and convert to decimal hours ? | DBenz | Excel | 5 | 01-26-2017 05:38 AM |
| Formula for decimal hours from two date time entries | DBenz | Excel Programming | 0 | 01-15-2015 05:52 AM |
| Search for date and then apply mutliple search criteria in huge dataset | maxtymo | Excel | 2 | 12-01-2013 04:52 AM |
| Formula to subtract one month from due date field in reminder field | ghumdinger | Outlook | 1 | 10-01-2011 12:09 AM |
 Date and time calcs excluding non-working hours
|
mrsatchmo | Excel | 1 | 01-26-2011 08:50 AM |
Windows 7 32bit 
Office 2010 32bit
Hybrid Mode