Tag: Get Time Based On Cost In Excel

Suppose Your Earning Hourly Rate Is $10.00. You Purchased An Item Of Cost $12.00 Now If You Want To Calculate The Time It Will Take You To Earn Those $2.00 Expense Money, We Can Use If Condition With Time Function And A Division Method With 24 Hours Turnaround. So Our Formula Will Be Like This:- FORMULA :- =IF(A3/B3/24 > TIME(1,0,0),(A3/B3/24) -TIME(1,0,0),"") NOTE:- For This Example If Hourly Rate Is Greater Than Purchased Item Rate Formula Will Return Blank. If You Want To Calculate That Too Then Please Use Only This Formula =B47/C47/24. By Division Of A3/B3/24 We Get 00:45:31 As A Time Value, This Means It Is Less Then A Hour So It Won't Calculate As Per This Example. We Have Used IF Condition To Compare The Time Generated By This (A3/B3/24) With Fixe...