N
Nik
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
eg. 11/10/04 12:00 and I want to add 8 hrs
P
Peo Sjoblom
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 edit>paste
special
and select add, then you probably have to reformat again
=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 edit>paste
special
and select add, then you probably have to reformat again
N
Nik
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!
I actually had to add 1/3 (i.e. 24 hrs / 8hrs = 3 hrs; therefore 1/3) but I
knew what you meant!
P
Peo Sjoblom
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
obviously is the same as 1/3
One day is 1 in Excel, so one hour is 1/24