Started By
Message

re: Need some Excel help

Posted on 1/14/15 at 12:05 am to
Posted by lynxcat
Member since Jan 2008
24236 posts
Posted on 1/14/15 at 12:05 am to
=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.
Posted by Guess
Down The Road
Member since Jun 2009
3781 posts
Posted on 1/14/15 at 12:18 am to
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.)
first pageprev pagePage 1 of 1Next pagelast page
refresh

Back to top
logoFollow TigerDroppings for LSU Football News
Follow us on Twitter, Facebook and Instagram to get the latest updates on LSU Football and Recruiting.

FacebookTwitterInstagram