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.

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

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

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

there should be there

Attached Files

Workbook3.xlsx (38.3 KB, 9 views)

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

Attached Files

Copy of Workbook3.xlsx (16.9 KB, 9 views)

__________________
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

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.

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