Time sheet formulas

[CommBPL]

Hi All,

I'm trying to establish a formula that calculates the total hours between a start and end time, but then if over 6 hours minus 0.5.

I've managed to do this in one cell calculating the hours =INT((G6-F6)*24) then in a separate cell taking away the 0.5 if over 6 =IF(H6>6, H6-0.5)

Is it possible to merge these two formulas together, so the total hours take away the 0.5 hours if over 6 hours in just one formula?

 

[Joe4]

Welcome to the Board!

Here is one way:

=LET(x,(G6-F6)*24,IF(x>6,x-0.5,x))

 

[CommBPL]

Thanks Joe, appreciate the welcome and the help with the formula! Perfect fix, thank you

 

[Joe4]

You are welcome.
Glad I was able to help!

I really like the new "LET" function!