Calculating a dollar value of the result between 2 different times

M

MSCurious

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
 
R

Roger Govier

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculate elapsed time excluding specific timeframe 10
Excel Facetime Measurement 1
Countifs with different restrictions 1
Time Zone Conversion Table 1
How to calculate difference between two date & time along with working hours and days 2
Calculating time for 3rd shift 4
Determine if night shift by start & end time 2
Calculating the difference, in hours, between two date/time in two different time zon 2

Top