Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding Minutes to Time
How do I add one minute at a time to a formula ... i.e. if the first cell =
9:00 I want to be able to add one minute to the next cell to result in 9:01 .... the following cell to equal 9:02 and so on ... ? -- Ken |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding Minutes to Time
Try this:
Assume your first entry is made in cell A1. Enter this formula in A1 and copy down as needed: =TIME(9,ROWS(A$1:A1)-1,0) This will return 9:00 AM. Format as h:mm and it will display as 9:00. -- Biff Microsoft Excel MVP "Ken" wrote in message ... How do I add one minute at a time to a formula ... i.e. if the first cell = 9:00 I want to be able to add one minute to the next cell to result in 9:01 ... the following cell to equal 9:02 and so on ... ? -- Ken |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding Minutes to Time
Ken
You could put 9:00 in A1 and 9:01 in A2, select both and drag down as far as you need. Formate as time with or with out AM/PM and it will incement. Mike Rogers "Ken" wrote: How do I add one minute at a time to a formula ... i.e. if the first cell = 9:00 I want to be able to add one minute to the next cell to result in 9:01 ... the following cell to equal 9:02 and so on ... ? -- Ken |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding Minutes to Time
=A1+TIME(0,1,0) or =A1+"00:01"
-- David Biddulph "Ken" wrote in message ... How do I add one minute at a time to a formula ... i.e. if the first cell = 9:00 I want to be able to add one minute to the next cell to result in 9:01 ... the following cell to equal 9:02 and so on ... ? -- Ken |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula for adding minutes to a time cell | Excel Discussion (Misc queries) | |||
Formula to find Stop Time from Start Time and Total Minutes | Excel Worksheet Functions | |||
calculating timesheet, time-in/time-out = total hours & minutes, . | Excel Worksheet Functions | |||
Using military time but with 100 minutes not 60 minutes | Excel Discussion (Misc queries) | |||
Adding minutes to time | Excel Discussion (Misc queries) |