| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Create Formula Using Select Values of a Cell
Give this formula a try...
=TEXT((LEFT(A1,LEN(A1)-6)&":"&MID(A1, LEN(A1)-5,2))-5/24,"d/mmm/yyyy hhmm""EST""") -- Rick (MVP - Excel) "Harpo" <Harpo @discussions.microsoft.com wrote in message ... Hello, I'm trying to create a formula using only select values of a cell. For example cell G1 has the following data: 12/Nov/2009 1620ZULU I'd like to create a formula which deducts five hours from the zulu time. Essentially I'd like the cell to read: 12/Nov/2009 1120EST Please help! Thanks in advance. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula to select values | Excel Discussion (Misc queries) | |||
| Using a formula to select a cell using the row and column values | Excel Worksheet Functions | |||
| select date range then find average of values in another cell | Excel Worksheet Functions | |||
| how can I select two different values for a cell? | Excel Worksheet Functions | |||
| Create a drop down in XL cell to select date | Excel Worksheet Functions | |||
Threaded Mode
