Adding time in cells

  • Thread starter Thread starter Scottie
  • Start date Start date
S

Scottie

Is there something I am missing..?? Normal numbers etc
the formula is rather easy.

What I am looking for is a way to add time to a previous
cell.

For instance, I drive a bus for the local city, I like to
make up a "cue sheet" of my schedule to keep in my pocket.

I can make it up manually but if I want to suggest
changes and I change things I would like to see if it has
an effect on further timeing points..

What I'd like to do is for instance have a cell say A2
with a specific time in it and have a subsequent cell say
B2 be dependent on A2 plus say 5 minutes and C2 be
b2+7minutes..

Can anyone help me on this??

Please carbon copy to my hotmail address if it's not too
much effort
 
Scottie, have a look here
http://www.cpearson.com/excel/datearith.htm

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 2003
** remove news from my email address to reply by email **
 
That works great.. however it appears something else has
gone wrong with the spreadsheet.

Thanks by the way..

Now where I have a few cells "merged" and when I want to
merge cells it won't let me.. the "merge" in format and
the little icon on the taskbar have become "greyed out"

Man hopefully this isn't a result of the previous one
 
Back
Top