• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Calculating % of total time

3G

3G

Member
Hi there,
I'm trying to figure out the % of time for a specific interval based on the total length of time for a task. For example, here's my data:

These are intervals of time BETWEEN two tasks. I need the metric of % of time for intervals between tasks.

Int 1 ||Int 2 ||Int 3 ||Int 4 ||Int 5 ||Total length
00:00:02||00:01:15||02:23:35||00:04:31 ||00:18:39 ||04:01:01

So, for example, 2 seconds (Int 1) is X % of 4 days, 1 hr, and 1 minute n(Total length). However, the % don't add up to 100. Wondering if someone can help me figure out what I'm overlooking. I've tried DATEDIF, and basic TEXT() type functions, but I'm just plain ole bombing.

Thanks!

3G
 
If the first number indicates 2 seconds, your total should be actually indicating 4 hours, 1 minute, 1 second using the same nomenclature. Also, the sum of your 5 intervals does not equal total length, so something is missing. Percentage formula should just be:
=Interval/TotalTime

So, either there are gaps in the time length that are unaccounted for somewhere, or data as been improperly entered.
 
Thanks Luke. Yeah, that's my problem! This just further highlights my issues I've already raised with the requester. :)
 
Ah, well, sorry we couldn't solve the issue, but hopefully you're able to stop banging your head against a wall (refering to profile pic). :)
 
You must log in or register to reply here.
Back
Top