About Paul_Carragher

Paul_Carragher · 06-08-2022

Hi All,I Built a time sheet app a number of years back together with many other projects. However I'm rusty. The time sheet has worked until the 19.05.22 when a number of issues appeared and cant seem to have it resolved. The issue stems from the Clo...

Paul_Carragher · 05-27-2019

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...

Paul_Carragher · 06-10-2022

Thanks for your reply Joseph.I understand it is way better to have a UniqueID, but our list of names are limited. Even so, I have tried to get the app working by adding a new ID column to the Employee spreadsheet and Timesheet spreadsheet. However I ...

Paul_Carragher · 06-08-2022

Hi Joseph, Possibly, but I'm not sure as this did not previously cause the problem. Making changes could lead me down a dark path.Playing around for the past hour or more to try and recall the process. Why is location list showing fine when this is K...

Paul_Carragher · 06-08-2022

Please see below imagesPic 1 pic 2 pic 3 pic 4 Prior to the issue we would add a name. This name would IF previously entered would appear in the list of pic 2. This is not happening. When adding new we receive warning as pic 4.Please let me know if t...

Paul_Carragher · 05-30-2019

Much appreciated all, works good. Well spotted @Gil

Paul_Carragher · 05-30-2019

Thanks Steve, unfortunately receiving the message IF function is used incorrectly:three inputs should be provided — (condition, if-result, else-result).

My Stats

Paul_Carragher's Bio

Badges Paul_Carragher Earned

Recent Activity

Timesheet app

Time Sheet Formula

Re: Timesheet app

Re: Timesheet app

Re: Timesheet app

Re: Time Sheet Formula

Re: Time Sheet Formula