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?