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?
|