=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?
.
|