C
Cactus-747
I want to make A1 “zulu time”, so with ESD time in cell B1, I put the
formula: =(B1+5/24) in A1.
Now I want to be able to make cell C1 Central time, D1 Mountain time,
and E1 Pacific time. I would obviously only use one respective time
zone for entry or I reckon I would get a value error. I thought the
formula would be something like:
=(B1+4/24)AND(C1+5/24)AND(D1+6/24)AND(E1+7/24). But that doesn’t work.
Any idea’s?
formula: =(B1+5/24) in A1.
Now I want to be able to make cell C1 Central time, D1 Mountain time,
and E1 Pacific time. I would obviously only use one respective time
zone for entry or I reckon I would get a value error. I thought the
formula would be something like:
=(B1+4/24)AND(C1+5/24)AND(D1+6/24)AND(E1+7/24). But that doesn’t work.
Any idea’s?