| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Extract time from date
Hi all, I have formated cell A1 in "dd\mm\yyyy hh:mm" and value
appearing is "26/08/2009 10:00". I need some formula in cell B1 to extract just the time bit from cell A1 value. I know I can copy cell A1 value into cell B1 and change the format into "hh:mm" and i'll get what i want but i dont want to do it that way. I need some thing like "RIGHT(A1,5)". I tried this but its not working. Please can any friend can help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to extract time and date | Excel Discussion (Misc queries) | |||
| extract date between a given time frame | New Users to Excel | |||
| Extract the hour from a cell showing the date and time | Excel Worksheet Functions | |||
| Calculating days & time left from start date/time to end date/time | Excel Worksheet Functions | |||
| extract time from excel serial date | Excel Programming | |||
![K[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
