I want to reference two different cell values into another formula but those values are returned using a formula.
In other words
The formula in
Cell F12 is =IF(C12<>"",NOW(),"") so lets say it returns a value of 5:50 PM
Cell G12 is the time manually inputted so lets say you input a value of 6:00 PM
if I want Cell K12 to show the amount of time elapsed - how do I write the formula?
also if I want to show an average time per task- lets say I performed 2 tasks in those 10 minutes
so if Cell H12 contains a manually inputted number "2" how do I
write a formula in Cell J12 to show average time per task.
In other words
The formula in
Cell F12 is =IF(C12<>"",NOW(),"") so lets say it returns a value of 5:50 PM
Cell G12 is the time manually inputted so lets say you input a value of 6:00 PM
if I want Cell K12 to show the amount of time elapsed - how do I write the formula?
also if I want to show an average time per task- lets say I performed 2 tasks in those 10 minutes
so if Cell H12 contains a manually inputted number "2" how do I
write a formula in Cell J12 to show average time per task.