#1
|
|||
|
|||
Total Hours * hourly rate
Hello,
I am trying to calculate my pay via hours and hourly rate but for some reason its coming out at £2. so far I have input 7hrs 30mins and rate is at £6.66 any ideas. |
#2
|
||||
|
||||
Again, it all depends how you enter time (in A1, say)
if its in sexagesimal format (07:30) try A1*24*hourly_rate If decimal (7.5) then A1*hourly_rate
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#3
|
|||
|
|||
didn't work
on April where the hours are they are in cell F8 to f20 and hourly rate is on Schedule page its in cell f4 |
#4
|
||||
|
||||
No file attached.
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#5
|
|||
|
|||
there should be there
|
#6
|
||||
|
||||
Your data is in sexagesimal format so you have to multiply by 24 as I indicated in my previous post.
Before stating " didn't work" please read and apply carefully what has been suggested. Also check the placement of you parenthesis. Something like =SUM(YOUR_RANGE*NUMBER) is not the same as =SUM(YOUR_RANGE)*NUMBER
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#7
|
|||
|
|||
sorry,
wondering if there is a possible way of just having one sheet with all the hours on and do a if cell is April it adds up cell f and so on. |
#8
|
||||
|
||||
You could build a list with following headers:
Date - Type - In - Out - Total Gross - Total Net Using SUMIF for example or SUMIFS ( if that exists in Office for Mac), you can extract date for each month and type or, better still using a Pivot Table
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Formula to determine Earned Hourly Rate | phowe43 | Excel | 2 | 06-02-2015 05:51 AM |
Adding of times total to be in hours | jen0dorf | Excel | 4 | 06-20-2014 11:53 PM |
How obtain accurate total of hours estimated of all subtasks that are a certain type? | pcumming | Project | 3 | 05-14-2014 05:45 PM |
Help: Very low response-rate! | Jeff10 | Office | 6 | 12-17-2013 10:44 AM |
Monthly Growth Rate Formula | meggenm | Excel | 2 | 04-22-2013 09:21 PM |