Calculating a dollar value of the result between 2 different times

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
Back
Top