Excel Help!

Like Tree10Likes
  • 2 Post By wanderlust
  • 2 Post By The New Black
  • 1 Post By CurlyCanadian
  • 2 Post By CurlyCanadian
  • 1 Post By wanderlust
  • 2 Post By divegirl

Is there a time function? I need to be able to add 5 minutes to every cell going down and can't figure it out!

So it would be
10:00
10:05
10:10

I've tried a few formulas and it keeps just giving me 10:00.
I believe in manicures. I believe in overdressing. I believe in primping at leisure and wearing lipstick. I believe in pink. I believe that laughing is the best calorie burner. I believe in kissing, kissing a lot. I believe in being strong when everything seems to be going wrong. I believe that happy girls are the prettiest girls. I believe that tomorrow is another day and I believe in miracles.
Audrey Hepburn
Is there a time function? I need to be able to add 5 minutes to every cell going down and can't figure it out!

So it would be
10:00
10:05
10:10

I've tried a few formulas and it keeps just giving me 10:00.
Originally Posted by CurlyCanadian
Hi CurlyCanadian, with 10:00 in A1, make sure that the entire column is in time format. In cell A2 type =(A1+5/1440). The 1440 is because there are 1440 minutes in a day and 5/1440 is the fraction of time that you want each cell to increment by. Then just copy the formula down as far as you need to.

This works but there may be better ways to do this. Hope that helps!
CurlyCanadian and curlypearl like this.
Formerly ladyjag123
Can't you: time format your column or row, type 10:00 in cell one and 10:05 in cell 2, then use the mouse to drag the little box in the bottom right corner of cell 2 down as far as you need it to go? Under the Format menu is there a box to set the time in increments of 5?
CurlyCanadian and curlypearl like this.
No MAS.

I am the new Black.

"Hope the Mail are saving space tomorrow for Samantha Brick's reaction piece on the reactions to her piece about the reactions to her piece." ~ Tweet reposted by Rou.

http://www.youtube.com/user/Kimshi4242

http://www.tumblr.com/blog/kimshi4242
Can't you: time format your column or row, type 10:00 in cell one and 10:05 in cell 2, then use the mouse to drag the little box in the bottom right corner of cell 2 down as far as you need it to go? Under the Format menu is there a box to set the time in increments of 5?
Originally Posted by The New Black
It should work that way!!! Stupid thing just keeps giving me errors Off to try it the other way and will report back!
Thanks
I believe in manicures. I believe in overdressing. I believe in primping at leisure and wearing lipstick. I believe in pink. I believe that laughing is the best calorie burner. I believe in kissing, kissing a lot. I believe in being strong when everything seems to be going wrong. I believe that happy girls are the prettiest girls. I believe that tomorrow is another day and I believe in miracles.
Audrey Hepburn
Can't you: time format your column or row, type 10:00 in cell one and 10:05 in cell 2, then use the mouse to drag the little box in the bottom right corner of cell 2 down as far as you need it to go? Under the Format menu is there a box to set the time in increments of 5?
Originally Posted by The New Black
I wonder if maybe this will work with the time format off?
I believe in manicures. I believe in overdressing. I believe in primping at leisure and wearing lipstick. I believe in pink. I believe that laughing is the best calorie burner. I believe in kissing, kissing a lot. I believe in being strong when everything seems to be going wrong. I believe that happy girls are the prettiest girls. I believe that tomorrow is another day and I believe in miracles.
Audrey Hepburn
WanderLust....you're awesome!!!!!!

Only issue, is when it hits 12pm, it goes to 0:00(in the 13:30 format). If I chance the format (1:30pm), in only comes up in AM. Can I change that?
I believe in manicures. I believe in overdressing. I believe in primping at leisure and wearing lipstick. I believe in pink. I believe that laughing is the best calorie burner. I believe in kissing, kissing a lot. I believe in being strong when everything seems to be going wrong. I believe that happy girls are the prettiest girls. I believe that tomorrow is another day and I believe in miracles.
Audrey Hepburn
Tried it TNBs way and it keeps diverting to a time function and I get errors. Thanks for the suggestion though!
The New Black likes this.
I believe in manicures. I believe in overdressing. I believe in primping at leisure and wearing lipstick. I believe in pink. I believe that laughing is the best calorie burner. I believe in kissing, kissing a lot. I believe in being strong when everything seems to be going wrong. I believe that happy girls are the prettiest girls. I believe that tomorrow is another day and I believe in miracles.
Audrey Hepburn
So I'm at my parents and doing these sheets for my Mom. My Dad is looking over my shoulder and is like "WTH is this hair thing?!?" I told him, he laughed at me, then even more when I said I would have an answer shortly!

It old him you guys had figured it out!!! When my Mom came back from the barn my Dad was telling her, then said "And the riders (the lists are for horse show start times) can now be sorted by hair type!!! We'll let the frizzy go earliest before it gets too humid!"
curlypearl and The New Black like this.
I believe in manicures. I believe in overdressing. I believe in primping at leisure and wearing lipstick. I believe in pink. I believe that laughing is the best calorie burner. I believe in kissing, kissing a lot. I believe in being strong when everything seems to be going wrong. I believe that happy girls are the prettiest girls. I believe that tomorrow is another day and I believe in miracles.
Audrey Hepburn
WanderLust....you're awesome!!!!!!

Only issue, is when it hits 12pm, it goes to 0:00(in the 13:30 format). If I chance the format (1:30pm), in only comes up in AM. Can I change that?
Originally Posted by CurlyCanadian
Hmm that is strange. When I try it, it goes to 12:00 p.m. Which version of Excel do you have? Mine is 2007.

When you tried using TNB's method, what type of error message did you receive?
CurlyCanadian likes this.
Formerly ladyjag123
My Dad says its 2010.

I would check, but on the deck with wine and a little lazy
I believe in manicures. I believe in overdressing. I believe in primping at leisure and wearing lipstick. I believe in pink. I believe that laughing is the best calorie burner. I believe in kissing, kissing a lot. I believe in being strong when everything seems to be going wrong. I believe that happy girls are the prettiest girls. I believe that tomorrow is another day and I believe in miracles.
Audrey Hepburn
I just tried this with Excel 2011 (for Mac):

Format the column as Time.

Put 10:00 in cell 1, and 10:05 in cell 2. Select BOTH cells and then drag the bottom right corner of the box down for as many cells as you need. You need to have both cells selected so Excel 'knows' to copy the increment.
CurlyCanadian and curlypearl like this.
Thanks!!!!

I'm not back up at my parents (it's saved on my Dads desktop) till next week some time, but will try that
I believe in manicures. I believe in overdressing. I believe in primping at leisure and wearing lipstick. I believe in pink. I believe that laughing is the best calorie burner. I believe in kissing, kissing a lot. I believe in being strong when everything seems to be going wrong. I believe that happy girls are the prettiest girls. I believe that tomorrow is another day and I believe in miracles.
Audrey Hepburn

Trending Topics


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT -6. The time now is 04:21 AM.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
Copyright 2011 NaturallyCurly.com