Total time to amount/currency

Please help me how to do this:

Column A
Name

Column B
Time In

Column C
Time Out

Column D
Total Time =TEXT(C4-B4,"h:mm")

Column E
Amount

What I need is to compute for the amount/currency of the total time. The amount is 30pesos per hour. 10pesos per 30minutes. Please help me guys. Thanks!

Not sure exactly what you are trying to accomplish, but try:

=E2/(D2*24)

HTH

Jason

Hi there,

Like Jason, I'm not too sure what you need but nonetheless I've set up the attached to hopefully solve the problem.

All data entry is made in the light green shaded cells (enter time as 24:00hr) and I've built the formula in cell E5 so that if an employee works any amount of time past 30 minutes, they will get a full hours' pay.

HTH

Robert