![]() |
|
#1
|
|||
|
|||
|
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
__________________
Using O365 v2503 - 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] |
|
|
|
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 |