#1
|
|||
|
|||
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 |
#2
|
||||
|
||||
=time allotted -time used and format as [h]:mm
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#3
|
||||
|
||||
Quote:
=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] |
Thread Tools | |
Display Modes | |
|
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 |