One way:
A1: 7:00 pm
A2: 5
A3: =A1+TIME(0,A2,0) === 7:05 pm
alternatively,
A3: =A1+A2/1440
which works since XL stores times as fractional days, so you need to
divide minutes by (24*60).
In article ,
"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?
|