HOW do I auto fill the hours and minutes between 8:00 and 3:30?

H

HappyGilmore

I'm trying to get the time to fill, like 8:00, 8:01, 8:02 etc for the
day. It keeps returning things like 8:02, 9:02, 10:02, etc. I'm new to
the game and have been reading everything I can, here and in books so
please forgive me for asking such a basic question.
 
J

JohnI

HappyGilmore,

The easiest way is to insert the first two (2) entries into the column e.g.

8:00
8:01

Then select both these cells, and drag down the bottom right-hand corner
square (black) of the selection down as far as you need.

Selecting two entries gives the fill-down a better idea of your
requirements.

regards,

JohnI
 
H

HappyGilmore

much appreciated. If you ever need any photoshop work done, or
woodworking, let me know. I owe you one.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculate time worked based on start / end times & working hours 3
Display Sum of hours as an equivalent in days and hours 2
How to convert half hourly data into hourly 5
Time calculation of 8:00 am - 4:30 pm at 8.5 hours How??? 3
Help for a newbie trying to add hours and minutes :) 8
enter time in simple text and convert to hours/minutes 5
How do I calculate time in excel (clock in and clock out 3
How do I convert standard time to 30 min increments? 3

Top