Time allotted minus time used with result in hour and minute

macropod · #3 04-29-2014, 05:03 PM

Quote:

Originally Posted by esther6086

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
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
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