![]() 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 151 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. ArchivesCategories |