How to calculate 1 hour is worth 1.175

It calculates 30 min as 30 not 50 (half of an hour)
so the outcome is less.

As Robert says, enter your times in a format excel recognises, i.e. with a colon like 19:00 and 21:30 then formula to give total earned is

=MOD(J2-I2,1)*24*1.175

where 1.175 is hourly rate

Thank you, it works like you said it would.
Jerry