ExcelBanter

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Time (https://www.excelbanter.com/excel-discussion-misc-queries/19769-time.html)

zandj

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

Mangesh Yadav via OfficeKB.com

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

- Mangesh

--
Message posted via http://www.officekb.com

vishu

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

All times are GMT +1. The time now is 12:28 PM.