((End_time-Start_time)*24*Hr_Rate)

"MSCurious" wrote:

I am trying to set up an excel sheet. One column holds the time in, another
holds the time out, the next holds the elaspe time. Based on the elapse
time, I need to apply an hourly rate to get a toal for the time in and time
out.

In Out Duration Hrly Rate Total
10:00:00 AM 5:40:00 PM 7:40 $ 50