Tonight I was trying to create an IF function to calculate a value based on whether the time in one column was under 10am or not. When Excel help - didn't, naturally I googled. Someone had a similar query at one of those experts answer sites in 2007 but the single answer given to that query didn't help me either.
Luckily one of Microsoft's support pages had a somewhat related discussion from which I could pull a guess about the information I might need to use. I scanned as far as an example IF function using a value called DATEVALUE and proceeded to experiment.
My =IF(E92<TIMEVALUE("10:00:00"),D92,D92+1)
As you might be able to guess this is calculating a date within another time zone. Given that the countries in my sheet play with Daylight Savings, I've considered playing with additional IFs to define TIMEVALUES from Daylight Savings start/end dates - but those dates change from year to year! More fun in store :D
Sunday, May 03, 2009
2 comments:
ABOUT COMMENTING HERE:
1. You can use some HTML tags, such as <b>, <i>, <a>
2. Apparently blogspot requires that we allow third party cookies for the darn feature to work. Sorry, nothing I can do about it - Google will lead you to instructions.
3. I don't generally post on contentious issues so I don't expect problems.
However, I will delete comments I consider:
disrespectful, destructive, irrelevant or SPAM, (even sucking up: praising my post without reason while linking to a business site).
Subscribe to:
Post Comments (Atom)
LinkWithin
<?php
ReplyDeleteThanks anonymous,
DeleteI had experienced the problem of < and > disappearing as if they were html tags before, and probably had the thought when pasting it over that I would have to code the < ; so I am going to blame the family for distracting me at the critical time. :-)