Billable time sheet

H

H. D. Rider

I am creating a new time sheet for my work and i would like some help.
=(B25-B24) in cell B26 this is time value 7.00 am – 8.15 am = 1hour 15 mins
this works great on its own.
=INT(B27)*18+(B27-INT(B27))*100/60*18 (18 being dollars value or 18 can
be a cell) to calculate hourly rate this work great on its own.
But when i change the above cell B26 to B27 then this Fomular does not work
=INT(B27)*18+(B27-INT(B27))*100/60*18
How do I make this work and still come up with the sum of $22.50 and not $2.50

Thank's
 
H

H. D. Rider

Hi thank you
It would of taken me a month of sundays to work this one out
Thank you very much your help was greatly appreciated
 

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

if command with tiers 2
Run time error '424' object required 7
probably really simple for most, but not me 4
Move sheet to another document with variable name 1
Time Format Problem 3
Get Month and Year ONLY from cell value 2
Code optimisation 5
Excel 2007 Erroneous Calculation of Elapsed Time 1

Top