adding days and times

E

excelguy

I want to add an amount of hours to a particular day and time during that
day. For example, I want Excel to compute what time and day it would be if I
add 6 hours to 6PM on Sunday (the first day of the week). In general, I want
to make a formula so I can figure out what time and day it would be for any
amount of hours I add so that I'd be able to figure out for example what time
and day it would be a million hours and 43 minutes from Sunday at 3:35pm. Any
Ideas?? thanks so much
 
S

Sheeloo

In Excel all dates are stored as number of days from 1/1/1900...
and time as a fraction with 1 equal to 24 hours or 1440 minutes...
so 0.5 equals 12:00 hours and 0 minutes on 1/1/1900.

If hours and minutes are in number format then you just need to divide the
minutes by 1440 and add to the date... If they are in date/time format then
just add to the date...

So if you have date in A1 and 300 in B1
then
=A1 + (B1/1440) will add 5 hours to the date in A1
if B1 has 5:00
then
=A1 + B1 will do the same ...
 
T

T. Valko

Just add the two together. If A1 contains the true Excel date/time 4/5/2009
3:35 PM and you want to add 48 hours 10 minutes:

A1 = 4/5/2009 3:35 PM
B1 = 48:10

=A1+B1

Returns 4/7/2009 3:45 PM

The largest amount of time *that can be manually entered* in a cell is
9999:99:99. If you need times greater than that then you'd have to enter it
as numeric integers and then convert the hours to days + the minutes.

For example, to add 10000 hours 10 minutes:

A1 = 4/5/2009 3:35 PM
B1 = 10000
C1 = 10

=A1+B1/24+TIME(0,C1,0)

Returns 5/27/2010 7:45 AM

If you want the weekday displayed use the custom format of:

dddd m/d/yyyy h:mm AM/PM
 

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

Top