I'm new to Excel and want to produce a spreadsheet that adds simple
times. For instance, I want to enter a certain time of the day in a
cell and then add 14 hours to that time in 24hr clock format. In the
next column I want to add 16:15 hours to that same beginning time.

What is the formula for his?

Thanks,

BJ

An easy way to add time is to use the TIME function:

To add 14 hours to A1:

=A1+TIME(14,,)

To add 16:15:

=A1+TIME(16,15,)

To roll over the hours, custom format the cells as
[hh]:mm.

HTH
Jason
Atlanta, GA

-----Original Message-----
I'm new to Excel and want to produce a spreadsheet that
adds simple
times. For instance, I want to enter a certain time of
the day in a
cell and then add 14 hours to that time in 24hr clock
format. In the
next column I want to add 16:15 hours to that same
beginning time.

What is the formula for his?

Thanks,

BJ

.

If the source time is in cell A1 then:
=A1+14/24
=A1+16.25/24

Troy

"B. Jensen" wrote in message
...
I'm new to Excel and want to produce a spreadsheet that adds simple times.
For instance, I want to enter a certain time of the day in a cell and then
add 14 hours to that time in 24hr clock format. In the next column I want
to add 16:15 hours to that same beginning time.

What is the formula for his?

Thanks,

BJ

Thanks Jason!

Jason Morin wrote:

An easy way to add time is to use the TIME function:

To add 14 hours to A1:

=A1+TIME(14,,)

To add 16:15:

=A1+TIME(16,15,)

To roll over the hours, custom format the cells as
[hh]:mm.

HTH
Jason
Atlanta, GA



-----Original Message-----
I'm new to Excel and want to produce a spreadsheet that


adds simple


times. For instance, I want to enter a certain time of


the day in a


cell and then add 14 hours to that time in 24hr clock


format. In the


next column I want to add 16:15 hours to that same


beginning time.


What is the formula for his?

Thanks,

BJ

.

Thanks Troy!

TroyW wrote:

If the source time is in cell A1 then:
=A1+14/24
=A1+16.25/24

Troy

"B. Jensen" wrote in message
...


I'm new to Excel and want to produce a spreadsheet that adds simple times.
For instance, I want to enter a certain time of the day in a cell and then
add 14 hours to that time in 24hr clock format. In the next column I want
to add 16:15 hours to that same beginning time.

What is the formula for his?

Thanks,

BJ