Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page time in minute format
Register FAQ

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 12-15-2015, 12:05 AM
xor xor is offline time in minute format Windows 10 time in minute format Office 2013
Expert
  
Join Date: Oct 2015
Posts: 1,101
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
If I understand you correct
A1: 10:20
A2: 8:40
A3: =A1-A2

Then =HOUR(A3)+MINUTE(A3)/60 formatted General
Reply With Quote
 

« Previous Thread | Next Thread »


Similar Threads
Thread Thread Starter Forum Replies Last Post
time in minute format How to write the degree, minute second format in excel Jamal NUMAN Excel 12 07-09-2018 11:44 PM
time in minute format Default date, time format when importing CSV files hwg Excel 3 11-17-2014 08:47 AM
Time allotted minus time used with result in hour and minute esther6086 Excel 2 04-29-2014 05:03 PM
time in minute format Run a macro each minute? yabbah Excel Programming 5 05-31-2012 01:01 AM
Changing format of time data Sammael Excel 2 04-08-2012 12:13 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:51 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