LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Time Formats Fran Excel Discussion (Misc queries) 1 May 10th 05 01:15 AM
can't format cell - have tried unlocking and unprotecting griffin Excel Discussion (Misc queries) 1 April 5th 05 02:11 AM
US vs UK date and time formats Stephen Glynn Excel Discussion (Misc queries) 2 February 24th 05 05:58 PM
Time formats in Excel 2003 Stephen Glynn Excel Discussion (Misc queries) 1 February 23rd 05 03:33 AM
Calculate between two time formats john86 Excel Worksheet Functions 3 February 11th 05 11:51 PM


All times are GMT +1. The time now is 11:49 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"