Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page Converting hh:mm to hours
Register FAQ

Reply
 
Thread Tools Display Modes
  #1  
Old 04-17-2012, 12:23 PM
Sammael Sammael is offline Converting hh:mm to hours Windows 7 64bit Converting hh:mm to hours Office 2007
Novice
Converting hh:mm to hours 		 
Join Date: Nov 2011
Posts: 8
Sammael is on a distinguished road
Default 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.
Reply With Quote
  #2  
Old 04-17-2012, 01:07 PM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Converting hh:mm to hours Windows 7 64bit Converting hh:mm to hours Office 2010 64bit
Expert
  
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,919
Pecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond repute
Default
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
Reply With Quote
  #3  
Old 04-17-2012, 01:33 PM
Sammael Sammael is offline Converting hh:mm to hours Windows 7 64bit Converting hh:mm to hours Office 2007
Novice
Converting hh:mm to hours 		 
Join Date: Nov 2011
Posts: 8
Sammael is on a distinguished road
Default
That worked. Thanks.
Much easier than I expected.
Reply With Quote
Reply

Tags
conversion, hours, time

« Previous Thread | Next Thread »


Similar Threads
Thread Thread Starter Forum Replies Last Post
Converting hh:mm to hours How to add hours together PomDave Excel 3 09-05-2011 04:43 AM
Converting hh:mm to hours Help with 'hours worked' calculation... Snvlsfoal Excel 1 08-11-2011 05:54 AM
Converting hh:mm to hours 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 08:38 PM.

Contact Us - Privacy Statement - Top

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft