I keep an excel sheet of all my expenses and I'm looking to convert the price of something I buy into the number of hours/minutes it would take me at work to earn that amount.
I make $14.25/hour which is $0.2375 cents per minute.
So if I buy something for $17.63, it should show as: 1 hour 14 minutes. ($14.25 = 1 hour, so $17.63 - $14.25 = $3.38 left over divided by $0.2375 cents a minute = 14 minutes.)
How can I get that to show up for each expense amount in a column?
Thanks!
Try:
Formula:
Please Login or Register to view this content.
and format as Time (hh:mm)
Replace those values with cell references, as needed - so it may look something like:
Hourly Rate: Item Cost Equivalent Time
Which gives:
Hourly Rate: Item Cost Equivalent Time
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks