Results 1 to 8 of 8

how to compute percentage of time looking at corresponding values in columns

Threaded View

  1. #1
    Registered User
    Join Date
    12-16-2009
    Location
    Germany
    MS-Off Ver
    Excel 2003
    Posts
    4

    Exclamation how to compute percentage of time looking at corresponding values in columns

    Dear all,

    I am new to excel and have a doubt in a particular computation. I would highly appreciate your help in this regard.

    1. Imagine 2 columns; A(having time displayed hh:mm:ss:ms format) & B (a value corresponding to time).
    2. Assume only 2 possible values for column B e.g. Val1 or Val2
    3. I would like to compute the percentage of time for which Val1 was in use & the same for Val2.

    Any ideas how this could be done? Please suggest me some possible ways of getting this done.

    Thanking you in advance,
    Andy13

    Added an excel sample to show the example. I hope this clears the issue little better.
    Attached Files Attached Files
    Last edited by andy13; 12-16-2009 at 09:02 AM. Reason: added attachment to elaborate example

Thread Information

Users Browsing this Thread

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

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