Calculate Wages
 

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

--
Regards
Frank Kabel
Frankfurt, Germany
"John" schrieb im Newsbeitrag
...
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

Thanks Frank, never knew what the [hh] format was for


"Frank Kabel" wrote in message
...
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" schrieb im Newsbeitrag
...
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