Solved

How can i change my time in Excel cells

Posted on 2011-02-11
11
248 Views
Last Modified: 2012-05-11
So I have this excel spreadsheet that has 1 minute intervals starting from column one all the way down to column 3000. example

12/7/2010 11:10
12/7/2010 11:11
12/7/2010 11:12
12/7/2010 11:13

How do I change the excel cells to represent 3 minute intervals as oppose to one. I dont want to have to redo the whole spreadsheet.
Was is the correct format to use.

Thanks
0
Comment
Question by:Powermgm
11 Comments
 
LVL 20

Accepted Solution

by:
Ardhendu Sarangi earned 250 total points
ID: 34873315
change the first three cells

12/7/2010 11:10
12/7/2010 11:14
12/7/2010 11:17

now select these three cells and drag down.

voila, you should be done.
0
 
LVL 30

Assisted Solution

by:SiddharthRout
SiddharthRout earned 250 total points
ID: 34873321
Just Type this and then drag it down

12/7/2010 11:10
12/7/2010 11:13

The cells will auto populate.

Sid
0
 
LVL 30

Expert Comment

by:SiddharthRout
ID: 34873326
xover

Sid
0
PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

 
LVL 30

Expert Comment

by:SiddharthRout
ID: 34873337
pari123: I guess you meant

12/7/2010 11:13

and not

12/7/2010 11:14

Sid
0
 
LVL 20

Expert Comment

by:Ardhendu Sarangi
ID: 34873364
sid,

jaise sunil pal ne bola - bhavanon ko samjho...:)

- Ardhendu.  
0
 
LVL 30

Expert Comment

by:SiddharthRout
ID: 34873374
bhavana to kab ki ja chuki ;)

Sid
0
 

Author Comment

by:Powermgm
ID: 34873588
Ok, so did the following created two cells as follows

12/7/2010 11:00
12/7/2010 11:03
12/7/2010 11:06

Select and drag all the way down the column. What am I doing wrong here?
0
 
LVL 30

Expert Comment

by:SiddharthRout
ID: 34873598
Nothing. It will populate automatically.

What results are you getting?

Sid
0
 
LVL 20

Expert Comment

by:Ardhendu Sarangi
ID: 34873737
if simple-drag doesn't work, try keeping CTRL pressed all the way. sometimes CTRL key works as a toggle... :)

- Ardhendu
0
 
LVL 24

Expert Comment

by:broomee9
ID: 35221179
This question has been classified as abandoned and is being closed as part of the Cleanup Program. See my comment at the end of the question for more details.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

733 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question