Link to home
Start Free TrialLog in
Avatar of Powermgm
Powermgm

asked on

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
ASKER CERTIFIED SOLUTION
Avatar of Ardhendu Sarangi
Ardhendu Sarangi
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
xover

Sid
pari123: I guess you meant

12/7/2010 11:13

and not

12/7/2010 11:14

Sid
sid,

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

- Ardhendu.  
bhavana to kab ki ja chuki ;)

Sid
Avatar of Powermgm
Powermgm

ASKER

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?
Nothing. It will populate automatically.

What results are you getting?

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

- Ardhendu
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.