Hi there,
Please help!
I am just trying to do a column of 'average rate' So if Joe Bloggs (Cell A5) has 35:00 hours of billable time (D5) and we charged out £3112 (H5) how much is the average rate per hour (L5). I know that this would be as simple as 3112/35=£88.91 per hour however most are like 35:26 (hours:mins) so I could turn it all into minutes in another column so it would be 2126(Cell B5) therefore =SUM(H5/B5)*60= £87.82 but can I do it without adding a new column?
Thanks,
Lisa
Bookmarks