Converting hh:mm to hours

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

FAQ

Thread Tools

Display Modes

04-17-2012, 01:07 PM

Pecoflyer

Windows 7 64bit Converting hh:mm to hours

Office 2010 64bit

Expert

Join Date: Nov 2011

Location: Brussels Belgium

Posts: 2,943

Pecoflyer has a reputation beyond repute

If your data is really a number of hours ( and not date/time formatted as hh:mm) try

Code:

=A1*24

and format as number

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Tags

conversion, hours, time

« Previous Thread | Next Thread »

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 09:49 PM.