Thread: Excel Formulas
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Chip Pearson Chip Pearson is offline
external usenet poster
 
Posts: 7,247
Default 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.