GolfGTIforum.co.uk
General => General discussion => Topic started by: leegt5 on 14 April 2012, 10:53
-
Say I have a cell with the value
date="1323816545000"
and I want to add 79600000 to that number any ideas ?
-
=sum(Cell?+ cell?)
-
Easiest way is like this:
(http://i1055.photobucket.com/albums/s507/Lankylad78/excel.jpg)
-
Sorry. Not very easy to see. Re-done picture for you:
(http://i1055.photobucket.com/albums/s507/Lankylad78/excel-1-1.jpg)
-
=sum(A1+79600000)
or if it says '#VALUE'
=(A1+79600000)
:nerd:
-
=sum(A1+79600000)
or if it says '#VALUE'
=(A1+79600000)
:nerd:
While this is right, it's always best to reference values from cells. If he had tons of cells that were "X + 79600000" then that number changed, it'd be a right pain going through changing everything again!
You can always put the number in say Column R, then right click on the column at the top and choose to hide the column :)
-
^ If you were using this number multiple times using this method it would be best to use the $ in your calculations. i.e. $R$1.
-
^ If you were using this number multiple times using this method it would be best to use the $ in your calculations. i.e. $R$1.
A bit of absolute cell referencing :cool: :grin:
-
=sum(A1+79600000)
or if it says '#VALUE'
=(A1+79600000)
:nerd:
While this is right, it's always best to reference values from cells. If he had tons of cells that were "X + 79600000" then that number changed, it'd be a right pain going through changing everything again!
You can always put the number in say Column R, then right click on the column at the top and choose to hide the column :)
or you could just click on the little box in the corner of the cell and drag it down, then it will automatically change the cell reference but keep the number it is adding the same :)
-
Cheers fellas. Im changing phones from Blackberry to Android. Managed to get my email accross ok, but my received sms messages are all 2 hours out from the Blackberry export and the timestamps are epoch time. In other words look like this "1323816545000".
Anyway I worked out the difference in epoch time and tried editing the received sms in the massive Blackberry export as a .csv which I did but I couldn't get it back into .xml to import into Android.
In the end I gave up !!