| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IS THERE A FORMULA TO MAKE E=6:00PM ETC SHIFT TIMES AND HOURS
First select the cells containing the letter you want to change and then
pull-down: Edit Find aand then enter e and then replace with 15:00 -- Gary's Student "Angel Devoid" wrote: i would like to know if excel could seek out a certain letter eg(E) and turn it in to a number eg e=15:00 as in what time the work shift finnishes. need to know a formula for it tried the "if" formula. =if(a2="E","15:00") which works untill you tell it too look in more then one cell because the cells have a mixture of E , LM , MID all diferent shifts. get my drift? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculation of hourly rate times hours times 1.5 | Excel Worksheet Functions | |||
| Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
| Avoiding typing similar formula 600 times | Excel Worksheet Functions | |||
| Formula to calculate elapsed time between certain dates and times | Excel Discussion (Misc queries) | |||
| How can I make a timesheet to figure my hours and payrate? | Excel Worksheet Functions | |||
Hybrid Mode
