Hi Excelians!
* Need a normal date calculation according to selected time zone.
* Formula required in [D7], facing problem in Negative TimeValue.
Please find the attached for detail.
Hi Excelians!
* Need a normal date calculation according to selected time zone.
* Formula required in [D7], facing problem in Negative TimeValue.
Please find the attached for detail.
Last edited by Debraj Roy; 09-04-2013 at 01:12 AM.
Regards!
=DEC2HEX(3563)
If you like someone's answer, click the star to give them a reputation point for that answer...
BTW..
You can Skip...
* Date calculation &
* Duplicate Abbr..
The attached spreadsheet was put up in response to another thread about date, time and time zones. May not be what you are looking for but have a look.
DATE & TIME.xlsx
Hi ursul..
Thanks for you prompt reply.. and hats off to your guess..
yes.. Its not the same what I am looking for..
Can someone please look into this..
In D7
=D3-VLOOKUP(F5,TimeZone,5,0)+VLOOKUP(C5,TimeZone,5,0)+(VLOOKUP(F5,TimeZone,5,0)>VLOOKUP(C5,TimeZone,5,0))
Life's a spreadsheet, Excel!
Say thanks, Click *
Hi Ace_XL..
will confirm and update you within few minute.. Thanks is advance..
WOW.. your binary logic works.. Thanks for the help..
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks