Excel Formatting help

[mattyj1085]

Does anyone know what formula I can use to convert a time in excel e.g 10:30 into text 10.30???

Cheers

 

[mattyj1085]

I need it to be stored as the number 10.30 not a time value.

 

[mattyj1085]

don't know to be honest its one of our users that wanted to know

 

[mattyj1085]

cant do as its in time format it changes it to for example 10:30 in time to 0.44 in number

 

[mattyj1085]

thats it thanks mate