time zone calculator

  • Thread starter Thread starter Ian R
  • Start date Start date
I

Ian R

Hi

Ive been trying to create a time zone calculator. I enter Local Time in one
cell and then the number of hours difference in another e.g +6 or -8 etc.

It only seems to work when adding hours. I get #num errors if I try
subtracting hours.

I thought this would be very easy but its proving extraordinarily difficult.

I'd be grateful if anyone can guide me on building a formula than can cope
with either adding or subtracting hours.

Thanks for any info.

Ian
 
Try adding and substracting fractions of a day instead. (i.e. one hour would be 1/24 of a day) this should solve your problem
 
Back
Top