Bright01
asked on
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
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
Or simply
=D3-C3+(D3<C3)
=D3-C3+(D3<C3)
ASKER
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.
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.
Format the cell as [h]:mm
ASKER
Got it. Now look at G. What is the formula I use to calculate the Amount?
Right now I'm using =(([@Hours]*Hourly_Rate)+[ @Additiona l]), but that's not working.
Thank you!
B.
Right now I'm using =(([@Hours]*Hourly_Rate)+[
Thank you!
B.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Seems so simple! Much thanks.....works great.
B.
B.
=D3-C3+IF(D3<C3,1)