|
|
|
|
#1
07-06-2016, 08:34 PM
|
|||
|
|||
You can get the exact number of hours, minutes and seconds by formatting the cell with your formula: [h]:mm:ss or just [h] if you only want number of hours.
If you want to round to hours for whole number of days you can change your formula to: =if(I2="", INT(Now()-C2), I2) 
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Record from output | gregi | OneNote | 0 | 02-15-2016 01:04 AM |
 Setting DPI for graphic output
|
ChrisBrewster | PowerPoint | 11 | 02-11-2016 09:12 AM |
|
30+ emtpy page output
|
Delcasa | Mail Merge | 4 | 04-30-2015 10:26 PM |
| mail merge – output to .pdf | eNGiNe | Mail Merge | 3 | 09-29-2013 11:45 PM |
| Output Presentation Settings | yeapurvz10 | PowerPoint | 0 | 09-17-2010 10:30 AM |
Windows 10 
Office 2016
Hybrid Mode