Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
conditional cell format based on cell in same row, previous column | Excel Worksheet Functions | |||
Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
Cell data format | Excel Discussion (Misc queries) | |||
Possible Lookup Table | Excel Worksheet Functions | |||
can't format cell - have tried unlocking and unprotecting | Excel Discussion (Misc queries) |