var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Subtracting Time in Excel
Trying to create a flight log sheet to convert zulu to local time, etc.
... and I want to convert minus 5 hours for eastern time local. (manual cell entry for -5 hours.)
Answer should be = 1/2/08 19:01
How do I do this??????
I think you need something like this
Where cell A3 = 1/3/08 0:01 and B3 = 5
Although I'm on UK date formats not US formats, but it should work OK.
Thanks for your input.
I should have mentioned that B3 in your example needs to be either a positive number, 0, or negative number. That is where I am running into problems is the negative number, for the NY time zone for example, converting from zulu.
Well .... yes, but what precisely is the problem ??
B3 in your example needs to be either a positive number, 0, or negative number