LinkBack URL
About LinkBacks
Cell A1 is Formatted as Time.
Cell B1 is Formatted as Currency
I worked 10 Hours(Cell A1)... I want PKR 322.6 as Answer (Cell B1)
Formula ?
Hint: Per Hour Rate is PKR 32.26....
Cell A1 is Formatted as Time.
Cell B1 is Formatted as Currency
I worked 10 Hours(Cell A1)... I want PKR 322.6 as Answer (Cell B1)
Formula ?
Hint: Per Hour Rate is PKR 32.26....
If your A1 cell is formatted as hours 10:00
=32.26*(A1*24)
format cell as number or currency.
if A1 cell looks like a number 10
32.36*A1
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Hi and welcome to the forum
Take a look at this thread, it seems to be pretty much the same as what you want...
http://www.excelforum.com/excel-gene...ual-money.html
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
and I posted there already... and Even got a reply from a Senior...Originally Posted by FDibbins
Hi and welcome to the forum
Take a look at this thread, it seems to be pretty much the same as what you want...
http://www.excelforum.com/excel-gene...ual-money.html
Please take a look.. and that thread didn't help Me...
Did you try the formula I provided in post #2?
=32.26*(A1*24) =32.26*A2
Last edited by AlKey; 10-14-2013 at 06:15 AM.
Actually, I figured out another method before Your reply...but I still need help at some points...
Still give it a look.. and tell Me if there's something wrong.. or its working perfect ? by the way.. do reply... as i still need some additions in the sheet and need Your help...
thanks..
SHEET : https://docs.google.com/spreadsheet/...Xc&usp=sharing
My comment wasnt suggesting you post a question there, just that answers on the other thread may be of use to you, sorry for the confusion
Also, please do not post workbooks on web hosting sites like google docs, not all members can access them...rather post here
Sorry .. .
But Dont know how to post it here ... ?
but i just found out how... il do it next time ..
Attachment didn't go as planned, please delete
Last edited by newdoverman; 10-14-2013 at 09:13 PM.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"
Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.
Salary Sheet Original sufi.xlsx
attachment
Please Check the Attachment...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks