View Single Post
  #1   Report Post  
Peter Kirk
 
Posts: n/a
Default 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