This is my setup: I am creating a log for a time event that I am doing (think It seems like running), split in split time with a compressed time, formatted as [hh: mm: ss.000] time values.
What I want to do is to find out how much time is in the form of a percentage of cumulative time
What I'm going to do, basically A6 (Segment) ) / A10 (cumulative time) * 100 , although this formula certainly does not work.
If the stop clock time (start with 0 in A0) So try below B2 in the form of suits and percentages:
= (A2-A1) / A $ 10 
No comments:
Post a Comment