Hi All,

I'm sure that this can easily be done but its a Monday and l'm
struggling!

I have many records that have been entered in cells which are formatted
for time entry
using Format, Cells, Special, hh:mm

I need to copy those cells, either using Excel functions or VBA, to a
number format but retaining the original figures.

ie 08:15 is copied and becomes 8.15 or 08.15
ie 14:35 is copied and becomes 14.35

Can anybody help please?

Regards

Michael Beckinsale