Converting my hours into dollars I'm a total novice!!!

[Rups27]

TIMES & WAGES CALCULATE

I'm a complete NOVICE when it comes to EXCEL. so, forgive the simpl
question and the need for a simply broken down answer (smiles

I've set up my very simple spreadsheet to track my hours worked

First column is DATES (31 days total)
then column B is a space column C is TIME ("time in")
then column D is a space column E is TIME ("time out")
then column F is a space column G is TIME ("time in")
then column H is a space column I is TIME ("time out")
then column J is a space column K is TIME ("time in")
then column M is a space column N is TIME ("time out"

column N is a spac
column O is where a put the function: =(E6-C6)+(I6-G6)+(K6-M6

At the end of the 31 days I've created a Grand Total of the hours
like so: =SUM(O6:O34

NOW, I want to create a function that lets me take the Grand Total o
the hours and multiply it by 65 Dollars. Basically converting m
hours into dollars!!

Sorry, for the long drawn out question. As you can see, I don't eve
know how to write it any shorter (more smiles

Thanks in advance
Rups

 

[Bob Phillips]

Rups,

All you need to is multiply the total number of hours by 24 to turn it into
a decimal, and then by 65. So if say A35 holds the number of hours
(SUM(O6:O34), and then you want the wages in B35, B35 becomes

=A35*24*65

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[gocush]

Try =((E6-C6)*24)+((I6-G6)*24)+((K6-M6)*24)
(Excel stores hours as a 24th of a day --- this should give you th
total hours worked each day.)

=SUM(O6:O34)
gets you the monthly hours and if this is in cell O:35 (I assume)

In cell O36 enter: 65.
In cell O37 enter: =O36*O35 to get the monthly dollar amt.

optional: format O37 as currency Format>cells>number>currency

With this you can adjust the $65 rate from time to time as needed.

If the location of the above cells dont fit you spreadsheet, the
adjust as needed