Format of Cell an Issue
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
|