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
|