numbers
Hi I have applied the unix time code formula
=(((A1/60)/60)/24)+DATE(1970,1,1)+(-5/24)
And it works! But the result I get on my column only shows the date and not the time. Does anyone know how to fix this? I attached an image to show what happens.
Thanks for your time.
The box on the top is the formula, the box on the bottom left is the "Formula Result" but the box in the row is the actual result I get.
I want the timecode too not just the date to appear in the rows.
It appears that this was a known issue.
The latest version released today (2015-11-11) Version 2.6.1 has this note:
- Resolves and issue where spreadsheets would not open back to their last saved positions.
See if updating to this latest version solves your issue.
So, this is easy to solve in Excel... I don't have access to Numbers at the moment, but I'll give you the solution I'm aware of and you can confirm whether it works in Numbers like it does Excel.
You can create a column with the following formula:
=Row() - 1
This will always give you one less than the "default" row number, which is what you are looking for. It also won't be affected by sorting.
A complete reference of functions that are available in Numbers can be found HERE, including the ROW function.
Best Answer
@Ashley is correct. For Numbers 3, Use the cell format to display the date and time the way you wish. I pasted in your formula in the cell B2 below: