adding time in Excell

  • Thread starter Thread starter Guest
  • Start date Start date
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 Format>Cells>Number>Custom [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)
 
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;528751 said:
How do I create a formula that adds time, ie. 6:30am to 4:30pm = 10
hours?
Click to expand...

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.
 
Back
Top