if function

[Turtle1425]

Hi all

i am trying to remove a 30 min break if someone has worked over 6 hours only and display it in column G.

Columns as follows

D= start time

E= Break time (30mins)

F=Finish time

G=results time in decimal converted from H

H= results pre decimal time

Can anyone please help i have tried =IF(H2>6,(G2-0.5)*G2*24) but it comes up FALSE, it may be me overthinking it.

Thanks

[#2 · Accepted solution]

@Turtle1425 

That could be

=H2*24-0.5*(H2>6/24)

[#3]

Hello @Turtle1425,

Without examining the attached file, I noticed that your formula lacks a key element of the IF() function. The syntax for IF() is:

IF(Logical_Test, Value_if_true, Value_if_false)

Your formula lacks a "Value_if_false", so if H2<=6 then your formula will simply return "FALSE" rather than "Value_if_false".

[#4]

@PReagan 

In addition, initial formula has circular reference since it is placed in G2

[#5]

Thank you all and this has solved it@Sergei Baklan 

[#6]

Thanks for the answer, although it has been solved it was helpful to lookunderstand were i went wrong

[#7]

:)
Thanks

[#8]

@Turtle1425 , you are welcome