View Single Post
  #2   Report Post  
Jason Morin
 
Posts: n/a
Default

=A1+TIME(,5,)

This will add 5 min.

HTH
Jason
Atlanta, GA

-----Original Message-----
I'm trying to create a timeline. If an event starts at

7:00 PM and the first
activity takes five minutes, it would then be 7:05 PM.

The next event takes
10 minutes, taking us to 7:15 PM, etc. I can't seem to

add minutes -- five
minutes becomes 12:05 PM and my timeline swings back and

forth from AM to PM.
Custom formatting can make the minutes look like

00:05:00, but the 12 hours
are still lurking there, messing up my timeline. Any

solutions?
.