Got some really good help on desk top shortcuts. Now I have another query.
What I want to do is track hours over any period i.e. the last 24 hours or the last 168 hours (a week).
I might work from 8:00 am to 11:00 am then 3:00 pm to 6:00 pm. I subtract the start from the finish time then sum the hours. This part is easy. What I now want to do is count the number of hours worked in the last 24 hours or the last week and be able to flag anything that exceeds a certain number of hours.
I’’m thinking something like
Now() – countif
But not sure how to put it together.
Thanks in advance.