Solved: Time Sheet Formula - Page 2

Paul_Carragher · 05-27-2019 03:22 PM

Hello,

(A) In my time sheet app I have the following expression. Is it possible to deduct 30mins from the computed total for lunch breaks.

IF(ISBLANK([Time Out]), “000:00:00”, [Time Out]-[Time In])

(B) I also have the following expression which works fine for auto complete the Time In, but for my activity column I would like each employees activity to be pre populated by their previous activity and not the previous activity carried out possibly by others.

ANY(SELECT(Timeheet[Time In],[_RowNumber]=[_THISROW].[_RowNumber]-1))

Regards
Paul.

Steve

IFS(
  ISBLANK([Time Out]),
    "000:00:00",
  (([Time Out] - [Time In]) < "004:00:00"),
    ([Time Out] - [Time In]),
  TRUE,
    ([Time Out] - [Time In] - "001:00:00")
)

View solution in original post