Time

[Guest]

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

 

[Mangesh Yadav via OfficeKB.com]

Multiply 8:15 with 24 and format as number with 2 decimals.

- Mangesh

 

[Guest]

short cut key is Ctrl+Shift+;