View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
mphell0
 
Posts: n/a
Default Agenda Time Formula


If column A has the start time and column B has the length of
presentation
(in minutes) then in A2 put

=A1 + TIME(0,B1,0)

and copy down as needed. Note this will only work properly when the
length
is in minutes.


--
mphell0
------------------------------------------------------------------------
mphell0's Profile: http://www.excelforum.com/member.php...o&userid=30153
View this thread: http://www.excelforum.com/showthread...hreadid=508916