|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
March 30th, 2005, 11:51 AM
|
|||
|
|||
Time
HOW DO I CONVERT Hr:Mn TO Hr IN EXCEL ie 8:15 to 8.25? Is there a short cut?
I am not hot on formulae in Excel 
|
|
#2
March 30th, 2005, 12:14 PM
|
|||
|
|||
|
Multiply 8:15 with 24 and format as number with 2 decimals.
- Mangesh -- Message posted via http://www.officekb.com
|
|
#3
March 30th, 2005, 01:49 PM
|
|||
|
|||
|
short cut key is Ctrl+Shift+;
"zandj" wrote: HOW DO I CONVERT Hr:Mn TO Hr IN EXCEL ie 8:15 to 8.25? Is there a short cut? I am not hot on formulae in Excel
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| unmet challenge | boris | Worksheet Functions | 2 | March 16th, 2005 02:13 PM |
| Overlapping time in Access | RobertMelton,MOUS | Running & Setting Up Queries | 2 | September 11th, 2004 03:06 AM |
| Function to add up total time taken? | Tails | New Users | 1 | August 9th, 2004 07:32 AM |
| Excel Formula Help please | Seventh Day is The Sabbath | Worksheet Functions | 3 | May 22nd, 2004 10:54 AM |
| Time Sheet calculations | John Tibbotts | Worksheet Functions | 1 | December 7th, 2003 05:21 AM |
Linear Mode
