![]() ![]() Normally this is done by preceding row and/or column identifier with a $. In spreadsheet terminology, "absolute address" refers to an address which will always point to the same place, even when the formula is moved or copied.INDIRECT(CELL("address")) converts that string to a cell reference again. You can use a combination of functions to do it, but it is clumsy and possibly not portable (in case your spreadsheet will be used with other software):ĬELL("address") will return a text showing the absolute address of the current cell.There is no specific name or function that points to "ThisCell".Is there a way to use a name like "thisCell" to refer to the current cell, instead of needing to input an absolute address? MeteoricDragon wrote:Your example is very helpful. Attachments sleeptime.ods (8.57 KiB) Downloaded 149 times ![]() Implemented as conditional formatting in the attached sample. Substitute proper cell addresses (and absolute addressing where applied) for "thiscell", "gotosleep" and "riseandshine". OR(MOD( thiscell 1)>$ gotosleep MOD( thiscell 1)$ riseandshine OR(MOD( thiscell 1)>$ gotosleep MOD( thiscell 1)$ gotosleep MOD( thiscell 1)<$riseandshine)) If the period of sleep time is always across midnight, sleep time is any point in time that falls after gotosleep or before riseandshine. You can use the MOD() function to extract the fractional part of a number, yielding a simpe time-of-day value to compare with sleep/wake times. The integer part of that underlying number corresponds to the date, and the fractional part to time of day. Internally, a spreadsheet stores date/time data as a number. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2022
Categories |