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 |
Format of Cell an Issue
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 EditPaste special...Values+Multiply, will remove the ' -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England www.nickhodge.co.uk HIS "John" wrote in message ... 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 |
All times are GMT +1. The time now is 05:22 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com