View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Scheduling - adding minutes to time

If you enter both as times, you could use:

=a1+b1

If you enter 3:43 as time and 38 as minutes, you could use:
=a1+(b1/24/60)

Make sure you format them as times.

Kelly wrote:

Is there a formula that can assist me with the following?

for example:

If I have a person scheduled for 3:43 and the meeting will take 38 minutes,
the ending time will be _____?

I want to plug in how long the meeting will be and get the new time.
--
Kelly C


--

Dave Peterson