Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 6
Default Calculations

I am not to good with Excel.

I have to make up a time sheet. Right now my "total weekly hours" box has a
time format of 'h:mm'. I need to calculate that by and hourly rate and then
into the dollar figure. Everytime I trie I get a very small fraction of the
actual dollar amount. Can someone help me?

an example: I worked 11:30 (11 and a 1/2 hours) at $15.00/hr. That should
equal $172.50 but Excel says it equals $7.19. I know I need to probably
convert the 11:30 to 11.5hrs but how?

Thanks in advance for the help
 
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
Calculations Pietro Excel Discussion (Misc queries) 7 February 20th 07 01:34 AM
IRR Calculations Allan Excel Discussion (Misc queries) 5 October 22nd 06 06:17 PM
Need help on some calculations.. KristopherJensen New Users to Excel 6 January 2nd 06 02:28 PM
! in Calculations Strata Excel Discussion (Misc queries) 4 December 14th 05 01:15 PM
Calculations Andrew Hodgson Excel Worksheet Functions 0 August 2nd 05 03:58 PM


All times are GMT +1. The time now is 08:47 AM.

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

About Us

"It's about Microsoft Excel"