How do I extract time only in Excel?

  • Thread starter Thread starter grant
  • Start date Start date
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
 
Then you didn't type it in properly. =Mod(a1,1) is a valid Excel formula.

Regards,
Fred.
 
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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can I extract the only second word? 6
Extract specific information from the body of outlook mail to an Excel File using VBA 0
How do i extract worksheet cells with the same contents? 1
how do I extract data from worksheet to VBA? 4
Excel Extract Text from decimal separated string 6
Extracting specific data from Date and time strings 3
How to extract time and date 2
data from multiple files: best way to extract 1

Back
Top