Hi all,

I’m trying to create a timesheet that calculates my hours while subtracting a potential unpaid break. Currently, what I have is =IFERROR(MOD(([@[Time Out]]-[@[Time In]])-([@[Unpaid Time End]]-[@[Unpaid Time Start]]),1)*24,0). This works, but only if values are inputted under the unpaid times. This is great if I do have an unpaid break. But what if I don’t take a break? I’d have to enter the exact same time under unpaid time in and unpaid time end (e.g., 2:00pm – 2:00pm), or else the hours worked for that day will stay 0. 

How do I rewrite the formula so that Unpaid Time Start/End is only calculated if time values are inputted? I really appreciate any help.

​Hi all, I’m trying to create a timesheet that calculates my hours while subtracting a potential unpaid break. Currently, what I have is =IFERROR(MOD(([@[Time Out]]-[@[Time In]])-([@[Unpaid Time End]]-[@[Unpaid Time Start]]),1)*24,0). This works, but only if values are inputted under the unpaid times. This is great if I do have an unpaid break. But what if I don’t take a break? I’d have to enter the exact same time under unpaid time in and unpaid time end (e.g., 2:00pm – 2:00pm), or else the hours worked for that day will stay 0.   How do I rewrite the formula so that Unpaid Time Start/End is only calculated if time values are inputted? I really appreciate any help.  Read More

​