#1
|
|||
|
|||
Getting an if to show output in hours
Something pretty simple here...
I have a spreadsheet that shows how many man hours a task took to complete. If the task is still in work the cell that shows the hours is blank. I have a date time column in my sheet that shows when the "clock starts ticking". My formula is Code:
=if(I2="", Now()-C2, I2) I want to see 120 (number of hours in 5 days) |
#2
|
|||
|
|||
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 |