Excel: Add time to a date and time column?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 edit>paste
special
and select add, then you probably have to reformat again
 
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 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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Subtracting time...again 2
separating date and time 5
Count entries in the column translating to minutes. 5
Time Sum in Excel 1
Calculate elapsed time excluding specific timeframe 10
Add Time Q 4
Date Time increment with additional condition of skipping weekends 13
Calculate hours, past midnight etc 4

Back
Top