Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
AndyM
 
Posts: n/a
Default How can I do an hourly salary calculation in Excel

How can i do a simple hours (and minutes) x hourly rate calculation and have
it display the correct amount in local currency
  #2   Report Post  
Peo Sjoblom
 
Posts: n/a
Default

If you are using excel time formats, assume a time value is in A2 and you
want to multiply with an hourly rate

=A2*24*rate

format as currency

--
Regards,

Peo Sjoblom

(No private emails please)


"AndyM" wrote in message
...
How can i do a simple hours (and minutes) x hourly rate calculation and
have
it display the correct amount in local currency


  #3   Report Post  
AndyM
 
Posts: n/a
Default

Thank you Peo!! Just what I wanted!

AndyM

"Peo Sjoblom" wrote:

If you are using excel time formats, assume a time value is in A2 and you
want to multiply with an hourly rate

=A2*24*rate

format as currency

--
Regards,

Peo Sjoblom

(No private emails please)


"AndyM" wrote in message
...
How can i do a simple hours (and minutes) x hourly rate calculation and
have
it display the correct amount in local currency



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 2 May 13th 23 11:46 AM
Excel: Area under a curve calculation Nick_C Charts and Charting in Excel 1 August 25th 05 03:44 PM
Excel lookup and calculation Spaz South Africa Excel Worksheet Functions 1 March 9th 05 03:43 PM
Difference in number of Excel NewsGroups Hari Prasadh Excel Discussion (Misc queries) 1 January 25th 05 12:32 PM
Excel - Time calculation Leyland Excel Discussion (Misc queries) 1 November 30th 04 08:43 PM


All times are GMT +1. The time now is 06:45 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"