Thread: [Solved] Getting an if to show output in hours
View Single Post
 
Old 07-06-2016, 10:30 AM
bremen22 bremen22 is offline Windows 7 64bit Office 2010 64bit
Advanced Beginner
  
Join Date: Jul 2013
Posts: 44
bremen22 is on a distinguished road
Default 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 would like my result to be in the number of hours. For example. the value in C2 = 7/1/2016 11:42:36. If this is posted 7/6/2016 13:28:14 the formula returns 5.34...

I want to see 120 (number of hours in 5 days)
Reply With Quote