Clockwheel in excel?
personBy Peter Symonds
access_timePosted 27 June 2015, 6.33pm edt
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.
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
Login or register to comment
It only takes a second with your Google or Facebook account.
- follow us on @minfodiscuss