You can edit it just as you would a normal timesheet entry, once it's been punched out - and have a validation option in the workflow. Failing that, you could modify the Hours column formula such that if the dates are different on an entry with status 'Punched out' then it calculates the number of work hours between start time and finish time - it works, but is tricky. This formula will generate an error in the Hours column if the user punches out the day after punching in, but will calculate the hours normally if the start and finish times are on the same day. =IF( NOT(ISBLANK([End Time])), IF( AND(Project=',(DATEDIF([End Time],[Start Time],'d')>0)), 7.5 * (DATEDIF([End Time],[Start Time],'d')+1), ([End Time]-[Start Time])*24),0). MANAGING PROJECTS AND TIME We can enhance your skills with courses for business at any of our twelve training centres UK wide, or we can come to your offices: if you have groups of three or more staff who need training, this is a very convenient, flexible and cost effective option. Moreover, most of our excel courses are 1 day, which keeps 'out of office' periods for attendees to a minimum. We have been delivering Microsoft Excel training all over the UK since 1995 and have continually developed our philosophy of high quality, flexible and results-driven provision of training for business to ensure constantly improving standards of quality. So you can be confident that we have the expertise, and the experience, to give you a great return on your investment in Free Excel Templates From Activia Training. Why not contact us today to see how we can help with providing your more software and IT productivity? Find free task list templates for Word and Excel, including templates for business projects, task analysis, to-do lists and day planners. Smartsheet for Outlook also requires Office 365, Exchange on-premise is not supported at this time. Project Management Templates: Basic Project with Gantt Chart & Dependencies, Gantt Project with Hard Deadline. Event Planning Templates: Event Task List with Gantt Chart and Budget, Simple Event Task Plan.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
March 2018
Categories |