Convert Cost Into Time 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 Fixed...