I have a list of time values in Excel which are formatted in hours, minutes and seconds as h:m:s, e.g. 1:01:21
I need to convert them all to minutes so that I can perform a calculation on the cells using a formula in a new column.
the Convert function doesn't seem to work as this just converts (say) hours to minutes, but my cells contain hours minutes and seconds.
Is there another way of doing this??
In the attached file, column B needs converting so that I can divide cost by minutes in column C