|
|
|
|
#1
05-12-2013, 07:14 PM
|
||||
|
||||
For periods less than a month, Excel can do this automatically without the need for macros, via a simple subtraction formula and a custom cell format (d h:mm:ss). For greater periods, a different formula can be used.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] 
|
|
#2
05-12-2013, 09:13 PM
|
|||
|
|||
|
attached a sample, it's not giving the result I need
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Compare columns + calculate difference
|
Inatic | Excel | 1 | 01-27-2013 08:00 AM |
|
Insert picture options, what's the difference?
|
Jennifer Murphy | Drawing and Graphics | 3 | 10-09-2012 05:12 AM |
|
5 days/week during planning & 7 days/week during implementation
|
sanlen | Project | 1 | 06-25-2012 04:17 PM |
|
What is the difference between the category and the distribution list?
|
Jamal NUMAN | Outlook | 1 | 11-21-2010 09:31 PM |
Windows 7 64bit 
Office 2010 32bit
Hybrid Mode