Calculate Wages

  • Thread starter Thread starter John
  • Start date Start date
J

John

I have a value of Hours worked as HH:MM and wish to calculate out wages due
i.e. multiply by Rate per Hour. My problem is if hours worked were 30:30
i.e. 30 hrs and 30mins multiplying the cell that says 30:30 by the RPH won't
give me the correct value say x $7.00 p.h. will give $212.10 instead of
$213.50. I've tried formating the cell of 30:30 to HH:MM but it gives me
06:30

How do I do I show the cell as 30:30 but the value calculated as $213.50?


Thanks
 
Hi
for the cell use the custom format
[hh]:mm
to show 30:30

as formula use
=A1*24*7
and format this resulting cell as number to calculate your wage
 
Thanks Frank, never knew what the [hh] format was for


Frank Kabel said:
Hi
for the cell use the custom format
[hh]:mm
to show 30:30

as formula use
=A1*24*7
and format this resulting cell as number to calculate your wage

--
Regards
Frank Kabel
Frankfurt, Germany
John said:
I have a value of Hours worked as HH:MM and wish to calculate out wages due
i.e. multiply by Rate per Hour. My problem is if hours worked were 30:30
i.e. 30 hrs and 30mins multiplying the cell that says 30:30 by the RPH
won't
give me the correct value say x $7.00 p.h. will give $212.10 instead of
$213.50. I've tried formating the cell of 30:30 to HH:MM but it gives me
06:30

How do I do I show the cell as 30:30 but the value calculated as $213.50?


Thanks
Click to expand...
Click to expand...
 
Back
Top