Formula for adding time

D

Doug AllPool

Fred this works the first time but tomorrow when I change the time in b2 the
time in b3 does not change.

I have been formatting all cells for time " 13:30 ". Is this correct?
Doug
 
F

Fred Smith

1. What happens when you press F9 (recalculate the workbook)? Do you have
Calculation set to automatic? In XL2007, use Excel button>Excel
Options>Formulas>Workbook Calculation>Automatic.
2. Use whatever format you want. Formats change only the appearance of the
cell. Calculations are independent of the format and will be the same
regardless of what format you use.

Regards,
Fred
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Countdown macro - display settings 2
Amending meeting cancels all future meetings 0
Formula for adding time 2
Formula for adding time 1
Checking for date and time overlaps 0
Table of content - format does not get saved 2
Nita Time formula 1
Copy addition formula of non-consecutive horizontal cells 2

Top