Originally Posted by
Pete_UK
You can use this formula in cell N2:
=IF(A2="","",LEFT(A2,2)+RIGHT(A2,8))
Apply a Custom Format to that cell of:
dd hh:mm:ss
then you can copy the formula into cells O2, P2 and Q2, and then copy those 4 formulae down to the bottom of your data. These will now be in numeric format and you will be able to perform arithmetic on them.
If you like, you could fix those values, and then copy/paste them back into the corresponding cells of columns A to D, and then you could delete columns N to Q.
Hope this helps.
Pete
Bookmarks