How do I create a formula that adds time, ie. 6:30am to 4:30pm = 10 hours?

Hi

It is unclear what you want.
the 10 hours you show is the difference you get if you subtract 6:30 AM from
4:30 PM
With 6:30 AM in A1, and 4:30 PM in B1

Time difference =B1-A1 FormatCellsNumberCustom [h]:mm
If time is likely to go over a 24 hour period use
=MOD(B1-A1,1)

If you are staring with the time in A1, and want to add 10 hours to it to
show the result that is in B1 then either
=A1+TIME(10,0,0)
or
=A1+10/24
The latter is because Excel stores times as fractions of a day (24 hours)
--
Regards
Roger Govier



"Lauramc" wrote in message
...
How do I create a formula that adds time, ie. 6:30am to 4:30pm = 10
hours?

See Chip Pearson's site for much info and formulas for working with times.

http://www.cpearson.com/excel/datetime.htm#AddingTimes


Gord Dibben MS Excel MVP


On Mon, 23 Jul 2007 16:12:02 -0700, Lauramc
wrote:

How do I create a formula that adds time, ie. 6:30am to 4:30pm = 10 hours?

Subtract the earlier time from the later time:

=time(16,30,0)-time(6,30,0)
or point at the cells.

=a1-b1
(say)



Lauramc wrote:

How do I create a formula that adds time, ie. 6:30am to 4:30pm = 10 hours?

--

Dave Peterson

It sounds like you want to subtract instead of add.

If A1 has 6:30 AM and A2 has 4:30 PM then =A2-A1 will return 10:00 AM.
Number formmating can be chosen to your taste.

If you are going across midnite (input 11PM and 1AM, expecting the result 2) then things get very dependant on your situation. The answer that I choose in that case (mostly) is to include date information when entering time. That has its problems, but other methods do as well.