Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Extracting Time from a cell that has both the date and the time
Hi Folks, I could do with some help here please. I am trying to extract the time only from a cell that has both the date and the time. Can anyone suggest a solution? Thanks in advance. -- Hani Muhtadi ------------------------------------------------------------------------ Hani Muhtadi's Profile: http://www.excelforum.com/member.php...o&userid=26794 View this thread: http://www.excelforum.com/showthread...hreadid=466177 |
#2
|
|||
|
|||
If you just wish the time to display, set the cell format to Time. If you wish to use the time portion then =A1-Int(A1) will give you the time that was in cell A1 Hope this answers your question. Hani Muhtadi Wrote: Hi Folks, I could do with some help here please. I am trying to extract the time only from a cell that has both the date and the time. Can anyone suggest a solution? Thanks in advance. -- Bryan Hessey ------------------------------------------------------------------------ Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059 View this thread: http://www.excelforum.com/showthread...hreadid=466177 |
#3
|
|||
|
|||
Just make a copy of the cell (e.g. A1) then in B1 insert =A1 and format B1
like "h:mm" Stefi €˛Hani Muhtadi€¯ ezt Ć*rta: Hi Folks, I could do with some help here please. I am trying to extract the time only from a cell that has both the date and the time. Can anyone suggest a solution? Thanks in advance. -- Hani Muhtadi ------------------------------------------------------------------------ Hani Muhtadi's Profile: http://www.excelforum.com/member.php...o&userid=26794 View this thread: http://www.excelforum.com/showthread...hreadid=466177 |
#4
|
|||
|
|||
Hi Hani,
If the date cell is A1, format the destination cell with a suitable time format and enter the formula: =A1-INT(A1) --- Regards, Norman "Hani Muhtadi" wrote in message news:Hani.Muhtadi.1v33mc_1126256719.5169@excelforu m-nospam.com... Hi Folks, I could do with some help here please. I am trying to extract the time only from a cell that has both the date and the time. Can anyone suggest a solution? Thanks in advance. -- Hani Muhtadi ------------------------------------------------------------------------ Hani Muhtadi's Profile: http://www.excelforum.com/member.php...o&userid=26794 View this thread: http://www.excelforum.com/showthread...hreadid=466177 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combining date and time into one cell | Excel Discussion (Misc queries) | |||
How do I calculate if a date is in a certain time frame? | Excel Worksheet Functions | |||
How to Join/concatenate a date field with a time field in Excel? | Excel Discussion (Misc queries) | |||
date and time | New Users to Excel | |||
Using formulas to determine date in one cell based on date in anot | Excel Worksheet Functions |