Results 1 to 6 of 6

Summation of Time Stamps

Threaded View

  1. #1
    Registered User
    Join Date
    12-08-2017
    Location
    Colorado, USA
    MS-Off Ver
    2016
    Posts
    3

    Exclamation Summation of Time Stamps

    Excel file has a running time stamp (00:00:00 up to 23:59:59). Three columns where values for certain rows oscillate between 0 and 1023, nothing in between those two numbers, just a 0 or 1023. What I would like to do is sum up the time elapsed for when a certain column reads 1023. I've tried SUMIF, but that simply adds up the hrs, min, and sec. I need to add up the time elapsed between the a column changes to 1023 and when it changes back to 0. It happens rather often.

    Looking for a formula where it will take the end of the time elapsed (i.e. when a value changes from 1023 to 0), subtract it from the beginning (i.e. when a value changes from 0 to 1023), and then repeat that for an entire column. Haven't had much luck so far.

    See attached workbook.
    Attached Files Attached Files
    Last edited by FMoynihan; 12-08-2017 at 12:38 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Create a Time Range off Time Stamps, and Count Intersecting values
    By athyeh in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-21-2014, 05:07 PM
  2. [SOLVED] Difference between two time stamps
    By Thinker8 in forum Excel General
    Replies: 2
    Last Post: 09-24-2013, 03:17 AM
  3. Converting time stamps to time intervals
    By enhydra in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-05-2011, 04:51 PM
  4. Time Difference in hours between two date time stamps
    By Cipher in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-17-2010, 10:24 AM
  5. Excel time-stamps - per row?
    By scottmcglasson in forum Excel General
    Replies: 1
    Last Post: 12-08-2008, 10:13 AM
  6. [SOLVED] I need to find the yy/mm/dd AND hh:mm:ss between 2 time stamps
    By Pontoon in forum Excel General
    Replies: 5
    Last Post: 06-22-2006, 08:25 AM
  7. time stamps detailing last save time
    By sam1 in forum Excel General
    Replies: 4
    Last Post: 01-12-2005, 03:21 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1