Cell formats, and time difference

Hi,
some simple questions which I hope someone can help with...

I am using excel on a computer with "danish locale". This means that numbers
are displayed default like 1234,56. How do I change this to a format using a
decimal point (instead of a comma)?

How do I find the difference between to times? I have cells which just have
times (not dates), and I want to find the difference between two times in
hours. For example cells with 08:00 and 09:30 should give a difference of
1.5
Excel help gives an example like =TEXT(B2-A2,"h"), but this gives an
error...

Thanks,
Peter

Peter,

I believe that you need to change the Regional settings in the control
panel. On the Regional Options tab, go to Customize.

For time, just subtract and multiply by 24 =(b2-A2)*24, and make sure the
cell is formatted as General not time.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Peter Kirk" <pk@alpha-solutions.dk> wrote in message
news:eHJtsEXYFHA.3220@TK2MSFTNGP14.phx.gbl...
> Hi,
> some simple questions which I hope someone can help with...
>
> I am using excel on a computer with "danish locale". This means that
numbers
> are displayed default like 1234,56. How do I change this to a format using
a
> decimal point (instead of a comma)?
>
> How do I find the difference between to times? I have cells which just
have
> times (not dates), and I want to find the difference between two times in
> hours. For example cells with 08:00 and 09:30 should give a difference of
> 1.5
> Excel help gives an example like =TEXT(B2-A2,"h"), but this gives an
> error...
>
> Thanks,
> Peter
>
>
>