Next Question
RSS
SETUP:
In the column where you want the times, type an appropriate header, such as "Time". In the next row down, type "10:00". Calc will assume this is a time and will append "AM", making it "10:00:00 AM". In the next row down, type "10:30". Again, Calc will make this "10:30:00 AM".
MAKING THE RANGE:
Highlight both times, then click and hold the black square on the lower right corner of the selection. Drag down. A pop-up will show you what time you have dragged to. Continue dragging until you reach the time you want, then release the mouse button. If you stopped early, you can select the last two times and repeat the process.
FORMATTING:
The format of the times, ##:##:## xM, is not likely what you want. Select the whole range of times, right click, select "Format Cells...". Choose the time format in the "Format" list that works best for you (I chose "01:37 PM"). You may need to select "Time" in the "Category" list if you have selected more than just the time cells in your sheet.
Source(s):
About 20 years using spreadsheets on the computer.
Tags: calc, excel, spreadsheet
Helpful Answer?
(1)
(0)
Permalink |
Report
Type in your first two times in the following format:
10/10/2009 10:00
10/10/2009 12:00
Then highlight the two times and a small black box will appear in the bottom right-hand corner of the 12:00 time. Putting your mouse over the top of that box will turn your mouse into a crosshair.
Click and drag that box to autofill the numbers as appropriate. Need a different interval? Then change the first two numbers and then drag instead.
Permalink | Report
Answered Question
M$3
October 06, 2009 03:13 AM
Using OpenOffice.org Calc, how can I create a schedule sheet?
I'm going to be running the screening room for an anime convention, and I would like to set up the left-hand column to be my list of times, that I can then fill in on another column.
What I'd like would be three sections listing Friday, 10 a.m. to midnight (12 a.m.); Saturday, 9 a.m. to midnight, and Sunday, 9 a.m. to 6 p.m, in half-hour increments. Then I can use succeeding columns to list what movies I'm actually scheduling there.
Please walk me through how to create these three ranges.
What I'd like would be three sections listing Friday, 10 a.m. to midnight (12 a.m.); Saturday, 9 a.m. to midnight, and Sunday, 9 a.m. to 6 p.m, in half-hour increments. Then I can use succeeding columns to list what movies I'm actually scheduling there.
Please walk me through how to create these three ranges.
Interesting Question?
Yes (0)
No (0)
- In Technology & Internet |
- Tags: openoffice, calc, list, spreadsheet, schedule |
- |
- Report |
-
Share
RSS
Best Answer Chosen by Asker
| October 06, 2009 12:07 PM |
In the column where you want the times, type an appropriate header, such as "Time". In the next row down, type "10:00". Calc will assume this is a time and will append "AM", making it "10:00:00 AM". In the next row down, type "10:30". Again, Calc will make this "10:30:00 AM".
MAKING THE RANGE:
Highlight both times, then click and hold the black square on the lower right corner of the selection. Drag down. A pop-up will show you what time you have dragged to. Continue dragging until you reach the time you want, then release the mouse button. If you stopped early, you can select the last two times and repeat the process.
FORMATTING:
The format of the times, ##:##:## xM, is not likely what you want. Select the whole range of times, right click, select "Format Cells...". Choose the time format in the "Format" list that works best for you (I chose "01:37 PM"). You may need to select "Time" in the "Category" list if you have selected more than just the time cells in your sheet.
Source(s):
About 20 years using spreadsheets on the computer.
| Asker's Rating: |
• Clear, concise, and definitely thorough. Good job.
Tags: calc, excel, spreadsheet
Helpful Answer?
(1)
(0)
Helpful: robotech_master
Tip shdwjk for this answer
Reply
Other Answers (1)
October 06, 2009 03:39 AM
Type in your headers as you want to see them: Time, Movie, Location etc. Type in your first two times in the following format:
10/10/2009 10:00
10/10/2009 12:00
Then highlight the two times and a small black box will appear in the bottom right-hand corner of the 12:00 time. Putting your mouse over the top of that box will turn your mouse into a crosshair.
Click and drag that box to autofill the numbers as appropriate. Need a different interval? Then change the first two numbers and then drag instead.
Permalink | Report
Reply
Answer this Question
Related Questions
Ask a Question
Buy Mahalo Dollars with Credit Card or PayPal
Top Members
Most Popular Tags
Categories
- Anonymous
-
Arts & Design
-
Beauty & Style
-
Books & Authors
-
Business
-
Cars & Transportation
-
Consumer Electronics
- Coupons Deals
-
Education
-
Entertainment
-
Environment
-
Fitness
-
Food & Drink
- From Email
- From Iphone
- From Twitter
-
Health
-
History
-
Hobbies
-
Home & Garden
-
How Tos
-
Humor
-
Jobs
-
Legal
-
Local
-
Love & Relationships
-
Mahalo Answers Community
-
Money
-
Music
-
News
-
NSFW
-
Parenting
-
Pets
-
Science & Mathematics
-
Services
-
Shopping
-
Social Science
-
Society & Culture
-
Sports
-
Technology & Internet
-
Travel
-
Video Games
Welcome New Members
- jdavison, November 30, 2009 11:55 PM
- jessicawiniskoz..., November 30, 2009 11:51 PM
- dkos, November 30, 2009 11:38 PM
- theconteshow, November 30, 2009 11:38 PM
- pattysu1, November 30, 2009 11:37 PM
Mahalo Dollars are the currency of Mahalo Answers.
Each Mahalo Dollar costs $1.
Once you earn more than 40 Mahalo Dollars, you can request to be paid via PayPal. Each Mahalo Dollar is currently worth $0.75 when paid out via PayPal. Learn More
