Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Time Formats | Excel Discussion (Misc queries) | |||
can't format cell - have tried unlocking and unprotecting | Excel Discussion (Misc queries) | |||
US vs UK date and time formats | Excel Discussion (Misc queries) | |||
Time formats in Excel 2003 | Excel Discussion (Misc queries) | |||
Calculate between two time formats | Excel Worksheet Functions |