| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changing Data in a Column
I have a column that has time ranges in it. Example: Column G Row 3 thru
253 has the following time ranges: 11am-1pm, 1pm-3pm, 12pm-5pm, 8am-12pm I need cells with 11am-1pm to read 13:00 I need cells with 1pm-3pm to read 15:00 I need cells with 12pm-5pm to read 17:00 Is there a formula that I can use the look up the entire column and make all the changes at once, or do I have to use the find a replace. The correct format can appear in a different column. Please help |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Changing Data in a Column
Try this formula...
=--SUBSTITUTE(SUBSTITUTE(MID(A6,FIND("-",A6)+1,11),"pm"," pm"),"am"," am") and format the cells to display the cell contents using the 13:30 Time format option. -- Rick (MVP - Excel) "DJordan" wrote in message ... I have a column that has time ranges in it. Example: Column G Row 3 thru 253 has the following time ranges: 11am-1pm, 1pm-3pm, 12pm-5pm, 8am-12pm I need cells with 11am-1pm to read 13:00 I need cells with 1pm-3pm to read 15:00 I need cells with 12pm-5pm to read 17:00 Is there a formula that I can use the look up the entire column and make all the changes at once, or do I have to use the find a replace. The correct format can appear in a different column. Please help |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing data in column for multiple rows | Excel Discussion (Misc queries) | |||
| Record changing cell data into a column or range | Excel Worksheet Functions | |||
| Changing entire column data | Excel Discussion (Misc queries) | |||
| How to set up a column to accept changing data from 1 cell on ano. | Excel Worksheet Functions | |||
| Changing the Direction of Data within a Column | Excel Worksheet Functions | |||
Hybrid Mode
