In column A, I have timestamp values. In a second column, I'd like to have a formula that would return words or strings like "early morning" or "Late afternoon", so that I may count and chart these responses. What formula am I looking for in Apple's Numbers?
Create a formula to provide a value depending on when a timestamp falls in the day
numbers
Related Solutions
- Select the columns with the data that you want to preserve.
- Choose Copy from the Edit menu (or hit Command ⌘+C).
- Choose Paste Formula Results from the Edit menu (or hit Shift ⇧+Command ⌘+V).
You should end up with just the results of the formula.
EDIT (Complete revision):
Based on your data, the only way to accomplish this without redesigning the table is to create separate charts for each Segment shown. As each segment has 4 pieces of data, this is the only way to do this. (There may be someone out there who is a charting expert that could do much better, I'm sure)
First, as you have done is to make a Total chart:
Then crate separate charts, positioned together for the segments:
The charts can be edited for looks and data views in the Inspector but that is beyond the scope of the question.
Related Question
- How to change y axis numbers in Numbers for mac to show as custom letters or words
- Lookup up cell values in Numbers
- Count number of text occurrences in column using Numbers
- (Numbers) COUNTIF values from one column match another column
- Numbers Sum of all values in a column where another cell within the row matches text
- MacOS – How to make calculations based on smart category summaries in Numbers
- Way to reverse the order of rows in a chart
Best Answer
Assuming you have a normal Numbers Date/Time
2/11/2016 12:00:00 AM, then a simpleIF()statement can be used combined with theHOURfunction.=IF( HOUR ( A2 ) < 12, "Good Morning", "Good Afternoon")To add more than just 2 options, nest your
IFstatement.=IF(HOUR(A3) < 5,"Early",IF(HOUR(A3) < 12,"Morning",IF(HOUR(A3) < 17,"afternoon",IF(HOUR(A3) < 20,"evening","night"))))Numbers will return the first TRUE value.