| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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
|
|||
|
|||
|
Multiply 8:15 with 24 and format as number with 2 decimals.
- Mangesh -- Message posted via http://www.officekb.com |
|
#3
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Time Sheets | Excel Discussion (Misc queries) | |||
| unmet challenge | Excel Worksheet Functions | |||
| entering numbers to display a time format | Excel Discussion (Misc queries) | |||
| Help - Information with time and date | Excel Discussion (Misc queries) | |||
| time formatting and time categorizing (vlookup or data validation) | Excel Worksheet Functions | |||
Linear Mode
