• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 252
  • Last Modified:

How can i change my time in Excel cells

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
Powermgm
Asked:
Powermgm
2 Solutions
 
Ardhendu SarangiSr. Project ManagerCommented:
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
 
SiddharthRoutCommented:
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
 
SiddharthRoutCommented:
xover

Sid
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
SiddharthRoutCommented:
pari123: I guess you meant

12/7/2010 11:13

and not

12/7/2010 11:14

Sid
0
 
Ardhendu SarangiSr. Project ManagerCommented:
sid,

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

- Ardhendu.  
0
 
SiddharthRoutCommented:
bhavana to kab ki ja chuki ;)

Sid
0
 
PowermgmAuthor Commented:
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
 
SiddharthRoutCommented:
Nothing. It will populate automatically.

What results are you getting?

Sid
0
 
Ardhendu SarangiSr. Project ManagerCommented:
if simple-drag doesn't work, try keeping CTRL pressed all the way. sometimes CTRL key works as a toggle... :)

- Ardhendu
0
 
TracyVBA DeveloperCommented:
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

Technology Partners: 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!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now