Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

How can i change my time in Excel cells

Posted on 2011-02-11
11
247 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:
pari123 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
Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

 
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:pari123
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:pari123
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

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

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

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
Many companies are making the switch from Microsoft to Google Apps (https://www.google.com/work/apps/business/). Use this article to learn more about what Google Apps has to offer and to help if you’re planning on migrating to Google Apps. It is …
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

839 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