[nfbcs] Times in Excel

[Nicole Torcolini]

That's actually what I was going to recommend. There is also a shortcut for
entering the same thing in all selected cells, but I cannot remember what it
is right now. I think that, if you wrote a value in A1 and =A1+15 in B1,
telling Excel to put the same formula in the entire column work as Excel
usually adjusts the formula.

-----Original Message-----
From: nfbcs [mailto:nfbcs-bounces at nfbnet.org] On Behalf Of Currin, Kevin
Sent: Friday, March 15, 2013 5:44 PM
To: NFB in Computer Science Mailing List
Cc: NFB in Computer Science Mailing List
Subject: Re: [nfbcs] Times in Excel

Could you do time 1 in say a1 and then put a formula for a1 plus 15 in b1
then b1 plus 15 in c1 and then copy the c1 formula down the column?

Sent from my iPhone

On Mar 15, 2013, at 8:39 PM, "Chun Chao" <zerone1683 at gmail.com> wrote:

> Unless I am calculating time across a column or row, I normally enter 
> the information into the cells manually.
> For example, I would first highlight column A, set the column type to 
> time,, and then type in the times manually such as 900 AM, 915 AM, 930 
> AM, 945 AM, and 1000 AM; the column type "time" will automatically 
> format the data to reflect what the entered information is supposed to
look like.
> I have still yet to see the column or row auto-fill function to insert 
> values in increments; my experience with the auto-fill feature is that 
> it just makes an exact copy of the first cell of the column or row.
> Excel has formulas for time but they are more for converting between 
> numeric values and time values as well as for calculating time difference.
> 
> C.C. Alan
> 
> -----Original Message-----
> From: nfbcs [mailto:nfbcs-bounces at nfbnet.org] On Behalf Of Steve & 
> Shannon Cook
> Sent: Friday, March 15, 2013 4:44 PM
> To: 'NFB in Computer Science Mailing List'
> Subject: [nfbcs] Times in Excel
> 
> Hi All,
> 
> Using JAWS 14, Excel 2010, and Windows 7.  Let's say for example in 
> column A, I have times starting at 9:00 AM.  How do I fill in the 
> cells below in increments of 15 minutes?  Thanks in advance!
> 
> 
> _______________________________________________
> nfbcs mailing list
> nfbcs at nfbnet.org
> http://nfbnet.org/mailman/listinfo/nfbcs_nfbnet.org
> To unsubscribe, change your list options or get your account info for
nfbcs:
> http://nfbnet.org/mailman/options/nfbcs_nfbnet.org/zerone1683%40gmail.
> com
> 
> 
> _______________________________________________
> nfbcs mailing list
> nfbcs at nfbnet.org
> http://nfbnet.org/mailman/listinfo/nfbcs_nfbnet.org
> To unsubscribe, change your list options or get your account info for
nfbcs:
> http://nfbnet.org/mailman/options/nfbcs_nfbnet.org/kwcurrin%40live.unc
> .edu
> 


_______________________________________________
nfbcs mailing list
nfbcs at nfbnet.org
http://nfbnet.org/mailman/listinfo/nfbcs_nfbnet.org
To unsubscribe, change your list options or get your account info for nfbcs:
http://nfbnet.org/mailman/options/nfbcs_nfbnet.org/ntorcolini%40wavecable.co
m