Excel: Add time to a date and time column?
 

How can I add time to a column in excel which contains both date and time?
eg. 11/10/04 12:00 and I want to add 8 hrs

Do you want to add it in a separate column? If so use

=A1+(1/8)

if you want to add the hours directly, put =1/8 in an empty cell
copy it, select all the date/times that you want it added to, do editpaste
special
and select add, then you probably have to reformat again

--
Regards,

Peo Sjoblom


"Nik" wrote in message
...
How can I add time to a column in excel which contains both date and time?
eg. 11/10/04 12:00 and I want to add 8 hrs

Thanks Peo :)
I actually had to add 1/3 (i.e. 24 hrs / 8hrs = 3 hrs; therefore 1/3) but I
knew what you meant!

"Peo Sjoblom" wrote:

Do you want to add it in a separate column? If so use

=A1+(1/8)

if you want to add the hours directly, put =1/8 in an empty cell
copy it, select all the date/times that you want it added to, do editpaste
special
and select add, then you probably have to reformat again

--
Regards,

Peo Sjoblom


"Nik" wrote in message
...
How can I add time to a column in excel which contains both date and time?
eg. 11/10/04 12:00 and I want to add 8 hrs

I apologize for the brain freeze, I actually meant to have typed 8/24 which
obviously is the same as 1/3
One day is 1 in Excel, so one hour is 1/24

--
Regards,

Peo Sjoblom


"Nik" wrote in message
...
Thanks Peo :)
I actually had to add 1/3 (i.e. 24 hrs / 8hrs = 3 hrs; therefore 1/3) but
I
knew what you meant!

"Peo Sjoblom" wrote:

Do you want to add it in a separate column? If so use

=A1+(1/8)

if you want to add the hours directly, put =1/8 in an empty cell
copy it, select all the date/times that you want it added to, do
editpaste
special
and select add, then you probably have to reformat again

--
Regards,

Peo Sjoblom


"Nik" wrote in message
...
How can I add time to a column in excel which contains both date and
time?
eg. 11/10/04 12:00 and I want to add 8 hrs