LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 77
Default How to multiply hours by a dollar amount

Thanks to Biff for helping me get the first of my timesheet problems figured
out. Now I am hoping to be able to take the amount of hours and multiply it
by a dollar amount to get a total.

So I want to take 25:30 (column a) and multiply that by $5 hour (column c)
to get a grand total.

So I put in: =a28*c28 and it gives me $3.92 which is obviously not right.

Column a is formatted as [h:mm] and column c is formatted as currency which
I think is where my problem is but don't know what I need to do to fix it.

Thanks for any insight.

 
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
multiply a text box on a report times a dollar amount gbpg Excel Discussion (Misc queries) 2 December 9th 07 09:33 AM
wages - multiply hours and minutes by number of hours worked Carol (Australia) Excel Discussion (Misc queries) 6 April 1st 07 01:16 AM
multiply hours/minutes times dollars for total dollar amount Anakin0303 Excel Discussion (Misc queries) 1 December 12th 05 06:43 PM
I need to find out how to multiply gross hours times amount of pay. Marc New Users to Excel 3 August 10th 05 03:38 AM
Hide row if dollar amount is zero Karl Irvin Excel Discussion (Misc queries) 5 May 7th 05 12:08 AM


All times are GMT +1. The time now is 03:44 AM.

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"