| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Adding minutes to time
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| entering numbers to display a time format | Excel Discussion (Misc queries) | |||
| Help - Information with time and date | Excel Discussion (Misc queries) | |||
| adding military time format | Excel Discussion (Misc queries) | |||
| Adding Subtracting Time Formula-Horse Racing | Excel Discussion (Misc queries) | |||
| Combined date time cell to separate date & time components | Excel Discussion (Misc queries) | |||
Threaded Mode
