WorldwideUKIrelandAustraliamore
media.info

Clockwheel in excel?

By Peter Symonds
Posted 27 June 2015, 6.33pm edt

Remove the ads and support us: GO PRO




I'm sure there are a few people know how to do this. I've basically got the minutes from and to. I've just want to put it in a representation of an hour. It sounds like it should be doable.

Comments

2 years, 1 month ago

Here's how I do it

Make a column working out the duration (aka To-From=Duration).
Then another column equaling the above sum, change the format of these cells to be a percentage.

Insert Chart type, pie chart.

You can create a column that'll do a running time total, and build in the link times as an even amount of the gap time to the top of the hour pretty easily too.

Here's a basic example, obviously all the titles and colours are editable around what you need it to do

https://docs.google.com/spreadsheets/d/1vWdPx80mPHcOzz8evr5bNwfvcDGtpI4S-V41pdtnFVM/edit?usp=sharing

Login or register to comment
It only takes a second with your Google or Facebook account.


- follow us on @minfodiscuss