| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Formulas
I need a formula to add 30 minutes to a specific time. (ex. from 1:00 PM to
1:30 PM. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel Formulas
Use a formula like
=A1+TIME(0,30,0) where A1 is the time to which you want to add 30 minutes. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "TSC Man" <TSC wrote in message ... I need a formula to add 30 minutes to a specific time. (ex. from 1:00 PM to 1:30 PM. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel Formulas
Or =A1 + 1/48 Regards Paul Martin Melbourne, Australia |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| E2007 formulas display as formulas, not results | Excel Worksheet Functions | |||
| Counting # of Formulas in a column with formulas and entered data | Excel Worksheet Functions | |||
| ms-excel guidence notes, complete formulas in excel, How to runmacros in Ms excel | Excel Discussion (Misc queries) | |||
| CELLS NOT CALC FORMULAS - VALUES STAY SME FORMULAS CORRECT?? HELP | Excel Worksheet Functions | |||
| Excel recalculates formulas when opening files last saved by an earlier version of Excel | Excel Programming | |||
Linear Mode
