Forum Discussion
Timesheet Help - Adding potential unpaid break
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 E...
Riny_van_Eekelen, I'm grateful for your response! It looks like that formula isn't much different than my current formula. My original formula also would've worked if I kept the columns under Unpaid Time Start and Unpaid Time End blank. I was hoping there would be a way to keep the text in there, but if not, I'll delete it.
I greatly appreciate your time. 
AmandaLPaull There is an alternative. With the proper custom number format, you can have the display of a number replaced by the display of specific text. See the attached workbook.