Getting an if to show output in hours

bremen22 · #1 07-06-2016, 10:30 AM

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)

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