Format of Cell an Issue

J

John

I have some Hourly Sales values coming from an Access database, these hours
are formatted as Text eg '1100 = 11am etc or perhaps I should say they are a
TEXT value but formatted as general

I am then adding up all hours between variable times, but with these TEXT
time values I can't seem to do it

Is there a way of automating some procedure that will 'convert' these TEXT
time values to true times i.e. removing the " ' ". My database is dynamic in
length


Thanks
 
N

Nick Hodge

John

Even removing the ' will not make them times. Excel will only recognise
times as hh:mm (with the colon)

To convert these 'numbers' though, put a 1 in a spare cell and then copy it.
Highlight the 'numbers' and Edit>Paste special...>Values+Multiply, will
remove the '

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
[email protected]
 
Top