Thread: Adding Times
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jason Morin Jason Morin is offline
external usenet poster
 
Posts: 63
Default Adding Times

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

.