| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Increment formula for time
Can a formula be used to increment times in a cell? A2 = 08/02/2006 2:00pm A3 = same date + 3 hrs (5pm) A4 = same date + 3 hrs (8pm) A5 = same date + 3 hrs (11pm) A6 = 08/03/2006 2:00am etc etc etc Thanx -- Ltat42a ------------------------------------------------------------------------ Ltat42a's Profile: http://www.excelforum.com/member.php...o&userid=24735 View this thread: http://www.excelforum.com/showthread...hreadid=567617 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Increment formula for time
Hi
Excel stores one day as 1. So three hours is 1/8 - as 3 hours is one eigth of a day. To increment by three hours, simply add 0.125 Hope this helps. Andy. "Ltat42a" wrote in message ... Can a formula be used to increment times in a cell? A2 = 08/02/2006 2:00pm A3 = same date + 3 hrs (5pm) A4 = same date + 3 hrs (8pm) A5 = same date + 3 hrs (11pm) A6 = 08/03/2006 2:00am etc etc etc Thanx -- Ltat42a ------------------------------------------------------------------------ Ltat42a's Profile: http://www.excelforum.com/member.php...o&userid=24735 View this thread: http://www.excelforum.com/showthread...hreadid=567617 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Increment formula for time
Enter this into A2 and drag down =A2+ TIME(3,0,0) -- VBA Noob ------------------------------------------------------------------------ VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833 View this thread: http://www.excelforum.com/showthread...hreadid=567617 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Increment formula for time
Ltat42a Wrote: Can a formula be used to increment times in a cell? A2 = 08/02/2006 2:00pm A3 = same date + 3 hrs (5pm) A4 = same date + 3 hrs (8pm) A5 = same date + 3 hrs (11pm) A6 = 08/03/2006 2:00am etc etc etc Thanx Hi Ltat42a, Try something like this Enter date in A2 in 24hour format 08/02/2006 14:00 In cell B1 type 3:00 (represents 3 hours and will automatically format to time) In A3 type formula =A2 + $B$1 Copy this down, date will increment by 3 hours oldchippy :) -- oldchippy ------------------------------------------------------------------------ oldchippy's Profile: http://www.excelforum.com/member.php...o&userid=19907 View this thread: http://www.excelforum.com/showthread...hreadid=567617 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Increment formula for time
Thanx everyone, all 3 examples worked fine. ...Ltat42a -- Ltat42a ------------------------------------------------------------------------ Ltat42a's Profile: http://www.excelforum.com/member.php...o&userid=24735 View this thread: http://www.excelforum.com/showthread...hreadid=567617 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Locking portions of a formula | Excel Worksheet Functions | |||
| assign formula to another cell | Excel Worksheet Functions | |||
| how to auto increment cell location within formula | Excel Worksheet Functions | |||
| "Unable to set the Formula property of the Series class" with a tw | Charts and Charting in Excel | |||
| adding row to forumla | Excel Discussion (Misc queries) | |||
Linear Mode
