Eileen Wrote:
I'm sure somebody knows this one. I need to get my hours worked when
not
complete hours to multiply by a number that represents the hourly pay;
what
is the formula when Excel counts 30 mins as .30 of an hour?

Don't you want 30 minutes to convert to 0.5?

If you have time worked in hh:mm format in A1 and hourly rate in B1

=A1*B1*24


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=515275