Forum Discussion

elyssag's avatar
elyssag
Copper Contributor
Nov 28, 2019

HELP with Multiple Work Hours calculations

I am creating a sheet which automatically removes break times when work times of a certain length are completed. I presently can automatically remove 30 mins from a shift of 8 hours with the formula;...
excel
Twifoo's avatar
Twifoo
Silver Contributor
Nov 28, 2019
Try this:
=A1-LOOKUP(A1,
{0,0.25,0.5},
{0,1/48,1/24})
  • elyssag's avatar
    elyssag
    Copper Contributor
    Nov 28, 2019
    Unless I'm entering it wrong, it doesn't work unfortunately.
    • Twifoo's avatar
      Twifoo
      Silver Contributor
      Nov 28, 2019
      I haven’t tested the formula because I’m replying through mobile phone. Anyway, what’s the result of the formula?
      • Twifoo's avatar
        Twifoo
        Silver Contributor
        Nov 28, 2019
        Try this revised version of the same formula:
        =A1-IFERROR(1/
        LOOKUP(A1,
        {0,0.25,0.5},
        {0,48,24}),0)

Resources