Excel Formulas

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

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 [email protected]> wrote in message
news:[email protected]...
>I need a formula to add 30 minutes to a specific time. (ex. from
>1:00 PM to
> 1:30 PM.

Or

=A1 + 1/48

Regards

Paul Martin
Melbourne, Australia