Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page Getting difference in time as a decimal and percentage of an hour
Register FAQ

Reply
 
Thread Tools Display Modes
  #1  
Old 05-23-2017, 05:01 AM
xor xor is offline Getting difference in time as a decimal and percentage of an hour Windows 10 Getting difference in time as a decimal and percentage of an hour Office 2016
Expert
  
Join Date: Oct 2015
Posts: 1,103
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default

=(13:30-11:15)*24 format as General.
Reply With Quote
  #2  
Old 05-23-2017, 07:22 AM
shabbaranks shabbaranks is offline Getting difference in time as a decimal and percentage of an hour Windows 7 64bit Getting difference in time as a decimal and percentage of an hour Office 2007
Advanced Beginner
Getting difference in time as a decimal and percentage of an hour 		 
Join Date: Mar 2011
Posts: 89
shabbaranks is on a distinguished road
Default
Quote:
Originally Posted by xor View Post
=(13:30-11:15)*24 format as General.
Worked a treat - thanks
Reply With Quote
Reply

« Previous Thread | Next Thread »


Similar Threads
Thread Thread Starter Forum Replies Last Post
subtract date and time and convert to decimal hours ? DBenz Excel 5 01-26-2017 05:38 AM
What is the formula for getting the percentage for time phoenix666! Excel 1 07-29-2016 08:18 AM
Time difference overnight medavidcook Excel 3 06-04-2015 05:01 AM
Formula for decimal hours from two date time entries DBenz Excel Programming 0 01-15-2015 05:52 AM
Time allotted minus time used with result in hour and minute esther6086 Excel 2 04-29-2014 05:03 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:20 AM.

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