Hi All

I just love the challange of fixing up someone elses dogs breakfast.

I have to sum a total amount of mins from 2 different time formatted cells.

I have no idea why it was setup this way, suffice to say my calls for it to
be changed have fallen on deaf ears by the brains trust, so here I am!

Column ("M").NumberFormat = "hh:mm:ss AM/PM"
It contains only Time

Column ("N").NumberFormat = "mm/dd/yyy hh:mm:ss AM/PM"
It contains Date/Time

With Column ("N")
1. Need to change format to a number. (copy to temp location)
2. Trim the 5 Leading numbers leaving only the decimal portion
3. Paste values from temp location bank to ("N")
4. change format to match Column("M")

TIA
Mick.