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
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
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" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>
Enter this into A2 and drag down
=A2+ TIME(3,0,0)
Hi Ltat42a,Originally Posted by 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
Thanx everyone, all 3 examples worked fine.
...Ltat42a
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks