A bit late, I opened the thread earlier then got sidetracked, only just returned to it.
In E20, then drag right.
This is the same formula that Ali suggested, but you will see that I have entered the Total Time range differently, the way that I have done it makes the column absolute so that you can drag it right without having to edit each one manually.
Note that the figures in column R have decimal values suppressed by formatting, meaning that Tuesday is actually 6.9 (6.88 rounded up to 6.9), not 6.8.
Bookmarks