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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Extract time from date
Use this...
=MOD(A1,1) and format the cell as Time. -- Rick (MVP - Excel) "K" wrote in message ... 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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Extract time from date
Hi,
=text(a1,"hh:mm") if this helps please click yes thanks "K" wrote: 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. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Extract time from date
Just so the OP knows, your formula as written, returns text, not a number.
If the OP needs a number, then he should use this... =--TEXT(A1,"hh:mm") -- Rick (MVP - Excel) "Eduardo" wrote in message ... Hi, =text(a1,"hh:mm") if this helps please click yes thanks "K" wrote: 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. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Extract time from date
thanks Eduardo
|
Reply |
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 |