calculating wages given hours worked and hourly wage

[dnajel]

HI can anyone help?

I have the follwing in my excel worksheet


start time / end time /

and I am calculating the hours difference between them an
it gives me a value now for each hour worked I would like
to apply a cost of lets say $10 how that can be done

start time 19:00 end time 20:30 = worked time 1:30 hour
now i need that that hour is converted to money i.e. $15
how can I do?

 

[Felipe I]

Hi,

=((End_time-Start_time)*24*hour_cost)

Regards,
Felipe

 

[Ragdyer]

I would suggest that you use 5 columns for your "PaySheet".
For example:
ColA = start time
ColB = end time
ColC = total time worked
ColD = pay rate
ColE = daily pay

In C1 enter:
=((B1-A1+(B1<A1))*24)*AND(A1<>0,B1<>0)

In E1 enter:
=C1*D1

This takes into consideration the possibility of the end time crossing
midnight.