How do I extract time only from a date/time cell in Excel?

One way:

A1 = 6/25/2008 12:05 AM

=MOD(A1,1)

Format as TIME

--
Biff
Microsoft Excel MVP


"grant" <(E-Mail Removed)> wrote in message
news:4375E5F1-BD59-4DC6-930F-(E-Mail Removed)...
> How do I extract time only from a date/time cell 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" <(E-Mail Removed)> wrote in message
> news:4375E5F1-BD59-4DC6-930F-(E-Mail Removed)...
> > How do I extract time only from a date/time cell in Excel?
>
>
>

Then you didn't type it in properly. =Mod(a1,1) is a valid Excel formula.

Regards,
Fred.

"grant" <(E-Mail Removed)> wrote in message
news0D11B4E-2B8E-4134-A6CE-(E-Mail Removed)...
>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" <(E-Mail Removed)> wrote in message
>> news:4375E5F1-BD59-4DC6-930F-(E-Mail Removed)...
>> > How do I extract time only from a date/time cell 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" <(E-Mail Removed)> wrote in message
news0D11B4E-2B8E-4134-A6CE-(E-Mail Removed)...
>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" <(E-Mail Removed)> wrote in message
>> news:4375E5F1-BD59-4DC6-930F-(E-Mail Removed)...
>> > How do I extract time only from a date/time cell in Excel?
>>
>>
>>

Another way:

=A1 - INT(A1)

Hope this helps.

Pete

On Jun 25, 5:19*am, grant <gr...@discussions.microsoft.com> 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" <gr...@discussions.microsoft.com> wrote in message
> >news:4375E5F1-BD59-4DC6-930F-(E-Mail Removed)...
> > > How do I extract time only from a date/time cell in Excel?- Hide quoted text -
>
> - Show quoted text -

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" <(E-Mail Removed)> wrote in message
> news0D11B4E-2B8E-4134-A6CE-(E-Mail Removed)...
> >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" <(E-Mail Removed)> wrote in message
> >> news:4375E5F1-BD59-4DC6-930F-(E-Mail Removed)...
> >> > How do I extract time only from a date/time cell in Excel?
> >>
> >>
> >>
>
>
>