Calculating a dollar value of the result between 2 different times
 

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

Calculating a dollar value of the result between 2 different times
 

((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

Calculating a dollar value of the result between 2 differenttimes
 

Hi

The hours are stored by Excel as fractions of a day. You need to multiply
the figure by 24 to get it to numeric hours.
In E2
=C2*24*D2

Regards

Roger Govier


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