Time

zandj · Mar 30, 2005

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 · Mar 30, 2005

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

- Mangesh

vishu · Mar 30, 2005

short cut key is Ctrl+Shift+;