Microsoft Office Forums

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

Reply
 
Thread Tools Display Modes
  #1  
Old 12-14-2015, 11:14 PM
orajesh orajesh is offline time in minute format Windows 7 32bit time in minute format Office 2010 32bit
Novice
time in minute format 		 
Join Date: Dec 2015
Posts: 3
orajesh is on a distinguished road
Default time in minute format
I have time in HH:MM format. how to make it MM format. Alternately I want to know the diffrence between 10:20 AM and 8:40 AM


I need the result as 100 or 1.66
Reply With Quote
  #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,097
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
  #3  
Old 12-15-2015, 12:46 AM
macropod's Avatar
macropod macropod is offline time in minute format Windows 7 64bit time in minute format Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,962
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default
Or:
=(A1-A2)*24
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #4  
Old 12-15-2015, 12:56 AM
orajesh orajesh is offline time in minute format Windows 7 32bit time in minute format Office 2010 32bit
Novice
time in minute format 		 
Join Date: Dec 2015
Posts: 3
orajesh is on a distinguished road
Default
Thank You.. Mr. Paul Works fine
Regards
Reply With Quote
Reply

« 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 12:33 AM.

Contact Us - Privacy Statement - Top

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