I need help creating a formula.
This is for a timesheet -
in Cell A1, employee types number of hours worked.
In Cell A2 is the formula for the Earned Comp Time (Time and Half = A1*1.5)



I only want the formula to work IF the number of hours in Cell A1 exceed 8 Hours. If 8.0 or less, I don't want anything to show in Cell A2

I.E.


Hrs Worked........|..8....|....12
Comp Earned......|.._....|....18

Any help making this IF formula would be helpful!

Hi and welcome

how does the employee enter the time ? Decimal ( like 1,5) or sexagesimal ( like 01:30:00) ?

__________________
Using O365 v2503 - 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

Decimal:
8.5 hr
or
7.92 hr

Try =IF(A1<=8,"",A1*1.5)

__________________
Using O365 v2503 - 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

YOU ARE WONDERFUL!!!
You made that look so easy!! I thought it was going to be some VLOOKUP or something!
THANK YOU!!

You're welcome and thank you for the rep. Most posters don't bother...

__________________
Using O365 v2503 - 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