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