Search for last date and first date and subtract to get hours

NoSparks · #1 04-06-2018, 12:42 PM

@ SavGDK

It appears to me there's going to be over 300 results for each of SP and PV, how and where are you wanting those results?

SavGDK · #2 04-06-2018, 12:55 PM

Quote:

Originally Posted by NoSparks

@ SavGDK

It appears to me there's going to be over 300 results for each of SP and PV, how and where are you wanting those results?

I have been putting the results in column E at the first occurrence of each 505 series. Right now that seems easiest because I need to capture the first date that the value occurred anyway.

Thank you,

dan

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