Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula for adding time
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula for adding time
1. What happens when you press F9 (recalculate the workbook)? Do you have
Calculation set to automatic? In XL2007, use Excel buttonExcel OptionsFormulasWorkbook CalculationAutomatic. 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 "Doug AllPool" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula for adding time | Excel Worksheet Functions | |||
Formula for adding time eg. 13:45 + 22:15 + 10:45 + 19:30 | New Users to Excel | |||
Time not adding in Formula | Excel Worksheet Functions | |||
Formula for Adding Time | Excel Discussion (Misc queries) | |||
what is the formula for adding up time intervals? | Excel Discussion (Misc queries) |