Converting hh:mm to hours

		Microsoft Office Forums > Microsoft Excel > Excel
Converting hh:mm to hours

04-17-2012, 12:23 PM

Sammael

Windows 7 64bit Converting hh:mm to hours

Office 2007

Novice

Join Date: Nov 2011

Posts: 8

Converting hh:mm to hours

I have time data formatted hh:mm and I need to turn them to hours.
For example 1:30 to 1.5 and so on.

I am using Excel 2007.

Tags

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to add hours together	PomDave	Excel	3	09-05-2011 04:43 AM
Help with 'hours worked' calculation...	Snvlsfoal	Excel	1	08-11-2011 05:54 AM
Converting decimal to hours	jhwtsang	Excel	4	05-16-2011 01:36 PM
Cell with hours	meninio	Excel	3	02-11-2011 06:50 AM
Help on the formulate hours	meninio	Excel	2	02-11-2011 04:56 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:22 AM.