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

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Search for last date and first date and subtract to get hours

FAQ

Thread Tools

Display Modes

04-06-2018, 12:55 PM

SavGDK

Windows 7 32bit Search for last date and first date and subtract to get hours

Office 2010 32bit

Novice

Join Date: Apr 2016

Location: Savannah Ga

Posts: 20

Posting solutions

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

Tags

date subraction

« Previous Thread | Next Thread »

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

Other Forums: Access Forums

All times are GMT -7. The time now is 12:17 AM.