Converting time into Dollars

EE Professionals,

I have a timesheet that has a Time-In and a Time-Out.  I am trying to calculate the amount of time that transpires between the In and Out record (Column E) and then simply multiply it times a Rate per Hour to give me a result.  I need the formula for calculating Column E.

Much thanks in advance,

B.
Calculating-Time-to-Money.xlsm
Bright01Asked:
Who is Participating?
 
Saqib Husain, SyedConnect With a Mentor EngineerCommented:
=E3*$B$1*24+I3
0
 
Saqib Husain, SyedEngineerCommented:
Try this formula

=D3-C3+IF(D3<C3,1)
0
 
Saqib Husain, SyedEngineerCommented:
Or simply

=D3-C3+(D3<C3)
0
Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

 
Bright01Author Commented:
ssaqibh,

Thanks for the formula.  Unfortunately it doesn't work.  4pm to 1am isn't .38 hrs. (Column E).

Can you take a look at the spreadsheet?

Thank you,

B.
0
 
Saqib Husain, SyedEngineerCommented:
Format the cell as [h]:mm
0
 
Bright01Author Commented:
Got it.  Now look at G.  What is the formula I use to calculate the Amount?

Right now I'm using   =(([@Hours]*Hourly_Rate)+[@Additional]), but that's not working.

Thank you!

B.
0
 
Bright01Author Commented:
Seems so simple!  Much thanks.....works great.

B.
0
All Courses

From novice to tech pro — start learning today.