- My Forums
- Tiger Rant
- LSU Recruiting
- SEC Rant
- Saints Talk
- Pelicans Talk
- More Sports Board
- Fantasy Sports
- Golf Board
- Soccer Board
- O-T Lounge
- Tech Board
- Home/Garden Board
- Outdoor Board
- Health/Fitness Board
- Movie/TV Board
- Book Board
- Music Board
- Political Talk
- Money Talk
- Fark Board
- Gaming Board
- Travel Board
- Food/Drink Board
- Ticket Exchange
- TD Help Board
Customize My Forums- View All Forums
- Show Left Links
- Topic Sort Options
- Trending Topics
- Recent Topics
- Active Topics
Started By
Message
re: Need some Excel help
Posted on 1/14/15 at 12:05 am to chrisman17
Posted on 1/14/15 at 12:05 am to chrisman17
=A1+TIME(0,29,0)
A1 is the start time and then the formula adds the 29 minutes. Drag that formula down for all time entries in column A and 29 minutes will be added to each associated row in column A.
Does this do what you need? Unclear on exactly the output you are looking for.
A1 is the start time and then the formula adds the 29 minutes. Drag that formula down for all time entries in column A and 29 minutes will be added to each associated row in column A.
Does this do what you need? Unclear on exactly the output you are looking for.
Posted on 1/14/15 at 12:18 am to lynxcat
quote:
=A1+TIME(0,29,0)
Unless I'm missing something, that only gives the correct answer in B1. Any additions to column A give nothing.
I tried B2:B1000000 as the range in the top left box and used =A2:A1000000+Time(0,29,0), but that still only gives the correct answer in B2.(note I'm starting from row 2 as the first row is reserved as the title from the form.)
Popular
Back to top
Follow TigerDroppings for LSU Football News