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

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)

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)