Convert a variable frequency square wave to a percentage

  • I have some data like this; 1000 1000 10 10 100 1111
    each number represents a second. I want to convert it to a percentage ie;


    25 25 25 25 25 25 25 25 50 50 50 50 33 33 33 100 100 100 100


    Any idea how to do it in excel for a lot of data?