Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 04-06-2018, 08:37 AM
SavGDK SavGDK is offline Search for last date and first date and subtract to get hours Windows 7 32bit Search for last date and first date and subtract to get hours Office 2010 32bit
Novice
Search for last date and first date and subtract to get hours
 
Join Date: Apr 2016
Location: Savannah Ga
Posts: 20
SavGDK is on a distinguished road
Unhappy Search for last date and first date and subtract to get hours

I have a large data set with multiple occurrences of a value of 505, I need to find the time the value 505 occurred and subtract the dates to get the total time the value 505 occurred.
I also need to do a similar subtraction to get the hours the column labeled PV was equal to or greater than 490, sometimes that occurs one value below the last occurrence of 505 in the SP column. Please see the attached workbook hopefully it will be more clear, the value in green is the dates I would need to subtract to get the hours the system was greater than or equal to 490. I have over 31,000 lines to get through so any help to automate this would be appreciated.

My spreadsheet also shows some formulas I have tried but with no luck.

Thank you,



dan
Attached Files
File Type: xlsx Time Subtraction File.xlsx (20.0 KB, 15 views)
Reply With Quote
 

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
Search for last date and first date and subtract to get hours 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 01:00 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft