Hi David

It seemed to work for me. I formatted a cell as text then typed in "10:30"
when I did a Paste Special/Multiply I got .4375 which when formatted as time
gave me 10:30.

If I was wrong I appoligize.

Regards!
Jean-Guy

"David McRitchie" wrote:

That would be an incorrect answer, because time
is a fraction of a day. Please read about time in
http://www.mvps.org/dmcritchie/excel/datetime.htm

---
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"pinmaster" wrote in message ...
Hi,

Try this:

Type the number 1 in a blank cell then copy the cell, next select your data
and do a Paste Special/Multiply then format as time.

Hope this helps!
Jean-Guy

" wrote:

Hi

I have imported a file to excel that contains data that looks like
time e.g 10:30 however the format of the data is General. How can I
get this data to show as an actual time in excel as I need to perform
further calculations on the time once I get it converted. I just need
it to show as hh:mm

Many thanks

W