Hi,
I know this should be simple, but I cannot figure it out so it's open to you please !
I have a 2 values.
Column A1 = £17.90 (total cost)
Column A2 = 00:02:00 (duration)
What I want to achieve is a cost per minute in Column A3 (which, in the example above would be £17.90 / 2 mins = £8.95)
Help please ?
try this:
Formula:
Please Login or Register to view this content.
and format as currency.
But you didn't say what for example with 00:02:35
Never use Merged Cells in Excel
Try
=A1/MINUTE(A2)
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Again esure cell containing formula is formalled as currency or number -
Regards
Please Login or Register to view this content.
Dave H
- Mark your post [SOLVED] if it has been answered satisfactorily, by editing your original post using advanced mode.
- Thank those that provided useful help, its nice and its very well appreciated...use the star on the lower left of the post
Many thanks all for your suggestions and help.
Dave H9's seem to work the best for my needs but thanks all.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks