Thread: Adding Times
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
TroyW[_2_] TroyW[_2_] is offline
external usenet poster
 
Posts: 94
Default Adding Times

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