Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 08-21-2014, 08:21 AM
zztops51 zztops51 is offline Windows 7 32bit Office 2010 32bit
Novice
 
Join Date: Aug 2014
Posts: 1
zztops51 is on a distinguished road
Default HELP! … I have a column in a spreadsheet that is formatted as follows

HELP! … I have a column in a spreadsheet that is formatted as follows:
2 H, 15 M
12 H, 9 M
12 H, 15 M
2 H, 9 M

I need to convert it to hours as:
2.25
12.15
12.25
2.15



Ideas?
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
My documents have been re-formatted??? Davec666 Word 2 04-30-2013 08:40 AM
Pre-formatted label printer jdorin Mail Merge 7 04-03-2013 12:14 AM
Automatically enter date into a column and make that column read only Mr Davo Excel 1 10-29-2012 01:07 AM
Can I change the horizontal scrollbar to scroll smoothly rather than column by column carpat Excel 0 01-10-2012 09:34 AM
Odd behaviour in formatted cells furface00 Excel 3 03-11-2011 08:02 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:25 AM.


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