Results 1 to 14 of 14

calculating multiple stop/start timers within a cell

Threaded View

kmfdm515 calculating multiple... 12-07-2010, 10:35 PM
Maistrye Re: calculating multiple... 12-07-2010, 11:30 PM
kmfdm515 Re: calculating multiple... 12-08-2010, 12:00 AM
Maistrye Re: calculating multiple... 12-08-2010, 12:10 AM
kmfdm515 Re: calculating multiple... 01-10-2011, 11:48 AM
kmfdm515 Re: calculating multiple... 01-21-2011, 10:52 AM
kmfdm515 Re: calculating multiple... 01-24-2011, 11:29 AM
kmfdm515 Re: calculating multiple... 01-24-2011, 11:36 AM
DonkeyOte Re: calculating multiple... 01-24-2011, 11:40 AM
kmfdm515 Re: calculating multiple... 01-24-2011, 02:20 PM
  1. #1
    Forum Contributor
    Join Date
    08-18-2004
    Posts
    108

    calculating multiple stop/start timers within a cell

    hi guys,

    in the attached sample file, i'm trying to figure out the "time to finish" for each item number. i have a start timestamp and an end timestamp. the result is a number of days to "finish".

    easy enough until i factor in that each item number can be suspended. i want to remove that time the item was suspended from my "time to finish" result.

    i have one column for the suspend start timestamp, and another column for the suspend stop timestamp. each is enclosed in a set of {}. it gets difficult because each cell here can have multiple timestamps within the {}, each separated by a comma (as seen in the sample file). so for an item suspended 3 separate time, a cell in column E would have 3 suspend start timestamps, and the corresponding suspend stop timestamps are in the next cell in column F.

    is there an easy way to do calculate the "time in suspend" in column G so I can subtract that from the time to finish in column D?
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

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