Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-28-2014, 03:58 AM
esther6086 esther6086 is offline Time allotted minus time used with result in hour and minute Windows 7 64bit Time allotted minus time used with result in hour and minute Office 2010 64bit
Novice
Time allotted minus time used with result in hour and minute
 
Join Date: Apr 2014
Posts: 1
esther6086 is on a distinguished road
Smile Time allotted minus time used with result in hour and minute

Need to keep up with time for a year on the time I am allotted minus the time I used and result in hours and minutes.

Thanks


Esther
Reply With Quote
  #2  
Old 04-28-2014, 09:59 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Time allotted minus time used with result in hour and minute Windows 7 64bit Time allotted minus time used with result in hour and minute Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,462
Pecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to behold
Default

=time allotted -time used and format as [h]:mm
Reply With Quote
  #3  
Old 04-29-2014, 05:03 PM
macropod's Avatar
macropod macropod is offline Time allotted minus time used with result in hour and minute Windows 7 32bit Time allotted minus time used with result in hour and minute Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,194
macropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant future
Default

Quote:
Originally Posted by esther6086 View Post
Need to keep up with time for a year on the time I am allotted minus the time I used and result in hours and minutes.
This requires nothing more than a simple subtraction. If the time allotted is in A1 and the time used is in A2, the time remaining requires nothing more than:
=A1-A2
in whatever cell you want to display the result in. Excel will automatically display the result in days, hours & minutes. If you have more than 24 hours, format the result cell's display as:
[h]:mm
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Time allotted minus time used with result in hour and minute Mail time--time zone? markg2 Outlook 3 09-18-2012 04:32 AM
IE Object: Run-time problem (the link is not clicked in run-time but not in step-in tinfanide Excel Programming 1 03-04-2012 12:05 AM
Average minus outliers? markg2 Excel 2 01-07-2012 05:46 PM
Time allotted minus time used with result in hour and minute Add a period of time to a referenced "Time" cell? derelyth Excel 4 03-27-2011 04:31 PM
Outlook take time ryangiam Outlook 0 08-27-2009 06:02 PM

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 07:14 AM.


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