Excel 2003-timesheet calculation problem

  • Thread starter Thread starter Rae
  • Start date Start date
R

Rae

I am trying to do up an excel spread sheet that can calculate no. o
hours worked after "time in" and "time out" are keyed. With the no. o
hours worked per day, sum them up to get total hours worked per month.
With the total hours worked, and hourly rated salary, calculate th
salary for the month. I formatted all the time cell to h:mm but th
resulting salary turns out to be 238:52:45 say for total hrs:36:45 an
hrly rate:6.50.attached is the fil

Attachment filename: timesheet_rae.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=60867
 
Hi Rae,

First set the format of the cell (where the final calculation of wages is done) to general or to Number. Then try this formulae

=(DAY(E35)*24+HOUR(E35)+MINUTE(E35)/60)*D37

I guess this should help you out.

Regards
 
Back
Top