G
grant
How do I extract time only from a date/time cell in Excel?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
T
T. Valko
One way:
A1 = 6/25/2008 12:05 AM
=MOD(A1,1)
Format as TIME
A1 = 6/25/2008 12:05 AM
=MOD(A1,1)
Format as TIME
G
grant
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
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
F
Fred Smith
Then you didn't type it in properly. =Mod(a1,1) is a valid Excel formula.
Regards,
Fred.
Regards,
Fred.
B
Bob Phillips
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)
=MOD(A1;1)
--
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
P
Pete_UK
Another way:
=A1 - INT(A1)
Hope this helps.
Pete
=A1 - INT(A1)
Hope this helps.
Pete
D
David Biddulph
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.
rather than a comma, then you'll need to use a semi-colon, rather than a
comma, to separate parameters in your Excel formulae.
G
grant
Fred, what is a continental Excel? (Do you mean US purchased? If so, yes.)
Thanks,
Grant
Thanks,
Grant