Date format to decimal format?

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

Hello Michael,

=--TEXT(A1,"[h].mm")

HTH,
Bernd

Hello Bernd,

Many thanks works as req'd.

I was on the right track back forgot to add the "" to [h].mm

Regards

Michael Beckinsale