Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Extract the hour from a cell showing the date and time
I have a field that shows Date and time in the same field. That shows like
this 1/3/05 12:06 PM I need to extract either 13:00 or 13 or 1 PM from this field. Text to collumns does not work. I need a formula. Can you help? Paul |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Extract the hour from a cell showing the date and time
Hi
I don't quite understand why you want 13:00, but as a start, try: =MOD(A2,1) This will 'chop off' the date bit, leaving just the time section. Hope this helps. Andy. "Paul Sexton" wrote in message ... I have a field that shows Date and time in the same field. That shows like this 1/3/05 12:06 PM I need to extract either 13:00 or 13 or 1 PM from this field. Text to collumns does not work. I need a formula. Can you help? Paul |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Extract the hour from a cell showing the date and time
Why not try HOUR() or HOUR(TIMEVALUE()).
Carl "Paul Sexton" wrote in message ... I have a field that shows Date and time in the same field. That shows like this 1/3/05 12:06 PM I need to extract either 13:00 or 13 or 1 PM from this field. Text to collumns does not work. I need a formula. Can you help? Paul |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
putting date and time together in 1 cell | Excel Discussion (Misc queries) | |||
Combined date time cell to separate date & time components | Excel Discussion (Misc queries) | |||
Combined date time cell to separate date & time components | Excel Discussion (Misc queries) | |||
Combined date time cell to separate date & time components | Excel Discussion (Misc queries) | |||
Combined date time cell to separate date & time components | Excel Worksheet Functions |