Min Time

[HappyChappy]

Hi have this formula =(G6*24)*$A$43 it refers to a start time and a finish time ie: 07:00 and 13:00 then it multipies it by A43 the amount per hour.
I want it to round to 8 hours pay as a minimum so if someone worked 8.45 or less it would be 8:00

Any help with this

many thanks

 

[StephenCrump]

Is this what you mean?

	A	B	C	D	E	F	G	H	I
1
2				Pay per hr	$12.00
3				Min Hrs	8
4
5					Start	Finish	Hours		Pay
6					7:00	11:00	4:00		$96.00
7					12:30	21:30	9:00		$108.00
8
Sheet1

Cell Formulas
Range	Formula
G6:G7	G6	=F6-E6
I6:I7	I6	=MAX(MinHrs,G6*24)*PayPerHr

Named Ranges
Name	Refers To	Cells
MinHrs	=Sheet1!$E$3	I6:I7
PayPerHr	=Sheet1!$E$2	I6:I7

 

[HappyChappy]

Is this what you mean?

	A	B	C	D	E	F	G	H	I
1
2				Pay per hr	$12.00
3				Min Hrs	8
4
5					Start	Finish	Hours		Pay
6					7:00	11:00	4:00		$96.00
7					12:30	21:30	9:00		$108.00
8
Sheet1

Cell Formulas
Range	Formula
G6:G7	G6	=F6-E6
I6:I7	I6	=MAX(MinHrs,G6*24)*PayPerHr

Named Ranges
Name	Refers To	Cells
MinHrs	=Sheet1!$E$3	I6:I7
PayPerHr	=Sheet1!$E$2	I6:I7

Nearly if the days worked have times in them it works a treat,
But if the day is a non worked day then the cells have 00:00 and 00:00 in them and this returns a min 8 hrs pays as well

 

[StephenCrump]

Try I6: =(G6>0)*MAX(MinHrs,G6*24)*PayPerHr

Or perhaps better still: =IF(G6=0,"nil",MAX(MinHrs,G6*24)*PayPerHr)

 

[HappyChappy]

Try I6: =(G6>0)*MAX(MinHrs,G6*24)*PayPerHr

Or perhaps better still: =IF(G6=0,"nil",MAX(MinHrs,G6*24)*PayPerHr)

Thank you for the help.