| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I extract time only in Excel?
How do I extract time only from a date/time cell in Excel?
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I extract time only in Excel?
One way:
A1 = 6/25/2008 12:05 AM =MOD(A1,1) Format as TIME -- Biff Microsoft Excel MVP "grant" wrote in message ... How do I extract time only from a date/time cell in Excel? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I extract time only in Excel?
I typed a date in cell A1, then typed =MOD(A1,1) in cell B1. Excel returns an
error stating "The formula you typed contains an error." I even used an example from Excel Help, =MOD(3, 2) and Excel returns the same error. Am I doing something wrong? -Grant "T. Valko" wrote: One way: A1 = 6/25/2008 12:05 AM =MOD(A1,1) Format as TIME -- Biff Microsoft Excel MVP "grant" wrote in message ... How do I extract time only from a date/time cell in Excel? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I extract time only in Excel?
Then you didn't type it in properly. =Mod(a1,1) is a valid Excel formula.
Regards, Fred. "grant" wrote in message ... I typed a date in cell A1, then typed =MOD(A1,1) in cell B1. Excel returns an error stating "The formula you typed contains an error." I even used an example from Excel Help, =MOD(3, 2) and Excel returns the same error. Am I doing something wrong? -Grant "T. Valko" wrote: One way: A1 = 6/25/2008 12:05 AM =MOD(A1,1) Format as TIME -- Biff Microsoft Excel MVP "grant" wrote in message ... How do I extract time only from a date/time cell in Excel? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I extract time only in Excel?
Do you have a continental Excel?
=MOD(A1;1) -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "grant" wrote in message ... I typed a date in cell A1, then typed =MOD(A1,1) in cell B1. Excel returns an error stating "The formula you typed contains an error." I even used an example from Excel Help, =MOD(3, 2) and Excel returns the same error. Am I doing something wrong? -Grant "T. Valko" wrote: One way: A1 = 6/25/2008 12:05 AM =MOD(A1,1) Format as TIME -- Biff Microsoft Excel MVP "grant" wrote in message ... How do I extract time only from a date/time cell in Excel? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I extract time only in Excel?
Another way:
=A1 - INT(A1) Hope this helps. Pete On Jun 25, 5:19*am, grant wrote: I typed a date in cell A1, then typed =MOD(A1,1) in cell B1. Excel returns an error stating "The formula you typed contains an error." I even used an example from Excel Help, =MOD(3, 2) and Excel returns the same error. Am I doing something wrong? -Grant "T. Valko" wrote: One way: A1 = 6/25/2008 12:05 AM =MOD(A1,1) Format as TIME -- Biff Microsoft Excel MVP "grant" wrote in message ... How do I extract time only from a date/time cell in Excel?- Hide quoted text - - Show quoted text - |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I extract time only in Excel?
If the list separator in your Windows Regional Options is a semi-colon,
rather than a comma, then you'll need to use a semi-colon, rather than a comma, to separate parameters in your Excel formulae. -- David Biddulph "grant" wrote in message ... I typed a date in cell A1, then typed =MOD(A1,1) in cell B1. Excel returns an error stating "The formula you typed contains an error." I even used an example from Excel Help, =MOD(3, 2) and Excel returns the same error. Am I doing something wrong? -Grant "T. Valko" wrote: One way: A1 = 6/25/2008 12:05 AM =MOD(A1,1) Format as TIME -- Biff Microsoft Excel MVP "grant" wrote in message ... How do I extract time only from a date/time cell in Excel? |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I extract time only in Excel?
Fred, what is a continental Excel? (Do you mean US purchased? If so, yes.)
Thanks, Grant "Bob Phillips" wrote: Do you have a continental Excel? =MOD(A1;1) -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "grant" wrote in message ... I typed a date in cell A1, then typed =MOD(A1,1) in cell B1. Excel returns an error stating "The formula you typed contains an error." I even used an example from Excel Help, =MOD(3, 2) and Excel returns the same error. Am I doing something wrong? -Grant "T. Valko" wrote: One way: A1 = 6/25/2008 12:05 AM =MOD(A1,1) Format as TIME -- Biff Microsoft Excel MVP "grant" wrote in message ... How do I extract time only from a date/time cell in Excel? |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I extract time only in Excel?
It wasn't me who talked about continental Excel, but, regardless, it's a
non-English version of Excel. Many of these versions use a semi-colon as a separator rather than a comma. If you have the US version, you don't have continental Excel. Regards, Fred. "grant" wrote in message ... Fred, what is a continental Excel? (Do you mean US purchased? If so, yes.) Thanks, Grant "Bob Phillips" wrote: Do you have a continental Excel? =MOD(A1;1) -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "grant" wrote in message ... I typed a date in cell A1, then typed =MOD(A1,1) in cell B1. Excel returns an error stating "The formula you typed contains an error." I even used an example from Excel Help, =MOD(3, 2) and Excel returns the same error. Am I doing something wrong? -Grant "T. Valko" wrote: One way: A1 = 6/25/2008 12:05 AM =MOD(A1,1) Format as TIME -- Biff Microsoft Excel MVP "grant" wrote in message ... How do I extract time only from a date/time cell in Excel? |
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I extract time only in Excel?
I think you'll find that it's not a question of where you bought your Excel,
but what you have set as your list separator in Windows Regional Options. -- David Biddulph "Fred Smith" wrote in message ... It wasn't me who talked about continental Excel, but, regardless, it's a non-English version of Excel. Many of these versions use a semi-colon as a separator rather than a comma. If you have the US version, you don't have continental Excel. Regards, Fred. "grant" wrote in message ... Fred, what is a continental Excel? (Do you mean US purchased? If so, yes.) Thanks, Grant "Bob Phillips" wrote: Do you have a continental Excel? =MOD(A1;1) -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "grant" wrote in message ... I typed a date in cell A1, then typed =MOD(A1,1) in cell B1. Excel returns an error stating "The formula you typed contains an error." I even used an example from Excel Help, =MOD(3, 2) and Excel returns the same error. Am I doing something wrong? -Grant "T. Valko" wrote: One way: A1 = 6/25/2008 12:05 AM =MOD(A1,1) Format as TIME -- Biff Microsoft Excel MVP "grant" wrote in message ... How do I extract time only from a date/time cell in Excel? |
| 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 | |||
| How do i extract the total editing time? | Excel Discussion (Misc queries) | |||
| Extract the hour from a cell showing the date and time | Excel Worksheet Functions | |||
| How do I extract the month end value from a daily time series? | Excel Discussion (Misc queries) | |||
Linear Mode
