I want to start at a date and at 12:00:00 am and I want each cell to increase by 1 hour. I put =a2+time(1,0,0) but I keep getting "The formula’s arguments can only include one date value." What am I doing wrong?
Mac – Why can I not have the date and time in one cell
macnumbers
Related Solutions
It does work in iCloud Numbers:
Select the cell you want the result in: i.e D2 of "Juice and Beverages"
And then in the text field at the top of the page enter:
=SUM('Units Sold' :: B2)
Take note of difference in how I have written it and how you did. Which was you main problem.
When done, click the green tick button on the right. And you will see this as the end result.
You can see some documentation on some of the included Functions by clicking into a cell and then into the:
1, text filed above:
2, you can search for a formula.
3,insert a Function template into the text field.
4, see a description of the Function and scrolling down further in the description you will see examples.
Might EOMONTH work for you?
The EOMONTH function returns a date that is the last day of the month some number of months before or after a given date.
Example: =EOMONTH("2/01/2015", 0) returns: Feb 28, 2015
Related Question
- Numbers: how to create a column with a sequence of times
- Getting the First Cell NOT Containing Certain Text in Numbers
- Mac – How to add the function to change the colour of a cell on numbers after a certain date has been passed
- In Numbers can you auto-populate a cell with a date when another cell is populated
- How to convert US-format date and time into a date value so I can use the local date format
- MacOS – iWork Numbers How To Calculate – In Once Cell Function – The Elapsed Time In Hours Between Two Date/Times
- How to add a calendar month to a date
Best Answer
You don't need a formula to display a date and a time together in Numbers but a formula would make life easier if you also wanted to have a list of cells with incrementally increased times on an hourly basis.
First, select (click on) the cell where your initial date is. Then, select the "Format" icon on the Numbers toolbar at the top and then select the "Cell" tab. In the Cell tab, choose "Date & Time" as the Data Format and then choose one of the Date format options in addition to one of the Time format options in the separate drop-down menus for Date and Time. The cell you just formatted should appear similar to
after these actions.
In order to display in another cell the time and date in the cell A2 as increased by one hour, you can use the following formula which utilizes the hour specification allowed in formulas. If the cell A2 has the starting date and time, put down the formula
, for example, into the cell right below (the cell A3) to get a date and time one hour later than the one in the cell a2. Assuming the cell A2 has the date and the time I used as an example previously, the cell A3 would appear similar to
after entering the formula and pressing return.
You can have the further incrementally increased hours as a list of dates & times if you copy and paste the formula in A3 to the cells below it.