Excel Formulas
 

I need a formula to add 30 minutes to a specific time. (ex. from 1:00 PM to
1:30 PM.

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.

Excel Formulas
 

Or

=A1 + 1/48

Regards

Paul Martin
Melbourne, Australia