duty

I have a sheet I created and mind you I am no expert wehre I have personell listed in a calendar type sheet in the left colums I have names and the top corresponds with the date there are certain duties that need to be performed and I have a number key for each duty so if on one day they have...

I am working on a Separation of Duties Form and I need a way to highlight or strike through a name if it is showing in multiple columns (Duty 1, Duty 2, Duty 3). The Form has 3 columns. The goal is if a name (Karen) is assigned in all three columns then we would like either a strike through her...

Please can you help me make an application that make a security gards duty. 1 - in the first sheet the table is like that: name - last date (mon to friday) - last date saturday - last date sunday 2 - in the second sheet the history for every gard duty name - 1-2-3-4-5- ........31(january...

Hi all, kindly require to provide me support so that to create a VBA code which should convert the minutes decimals in col. "L" to hours multiplying by 0.60. On my first below extract i appear the original data and on second i appear the expected result. e.g. 01-Aug-2018 9.67 should be 9.40...

I am trying to build DA6 form (military duty roster form) that uses excel, but takes into consideration a Soldier's weighted percentage that is based on a few variables such as number of times Soldier has done duty, if the duty was on the weekend, was the duty a priority 1 vs a priority 3, and...

From the below. worksheet1 : In worksheet1 "duty" column. I need to find out what duty "worker" last had during work_order_date. Bill on work_order_date 08/01/2017 & 08/05/2017 should report back as "welder" because he was not yet a manager until 8/15/2017. worksheet1 Bill work_order_date...