View Single Post
  #5   Report Post  
GD
 
Posts: n/a
Default

Hello !
A1=7:00 PM
A2=5
A3=A1+(A2*"0:1")

HTH

@+
geedee

Randberger wrote:
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?