if A1 = 02:30 and B1 = 07:00
then you can use:
=MOD(A1-B1+"24:00","24:00")
to get 19:30
"Amnon Wilensky" <wilensky[ at ]isdn.net.il> wrote in message
news:OKsRbAO5GHA.4832[ at ]TK2MSFTNGP06.phx.gbl...
[Quoted Text] > Hi,
>
> I want to convert Israel time to U.S time. Every thing is going fine until
> the number become negative. For example: if the time in Israel is 02:30
> and I want to find what is the time at New York I have to subtract 7:00
> hours, and I Excel don't calculate it.
>
> Any help?
>
> Thanks,
>
> Amnon
>
|