I am trying to do a simple increment of a time value as follows:
Cell C2 = 7:00AM and is set as a time data type.
Cell D2 has the formula =C2+15
The result is 7:00AM instead of 7:15AM
What is the correct way of doing this? I know I am wrong but, I cannot find a way.
iWorks - Numbers
In the first cell enter:
="7:00 AM"
in the next cell enter:
=C2+"15m"
He,
TheTime format is a particular way of displaying a Date-Time combination value. All dates include time, and all times include dates, whether you need it or not. If you don't need it, this fact can get in the way but is easily circumvented.
Further, to explain what you got, the unit of Date-Time is Days by default. So, if you add 15 to a Date-Time value, you get the same time on the date 15 days later. That's why 7:00 am today plus 15 is still 7:00 am, but it's 7:00 am 15 days later.
Wayne's "15m" is a Duration value. It is permissible to add a Duration value to a Date-Time value, the result being another Date-Time value. Or, if you want your calculations to be Date-independent, you can do the entire calculation in Duration format.
Regards,
Jerry
How can I do a simple time increment in Numbers?
