[nfbcs] Times in Excel

[Currin, Kevin]

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
>