Recording working hours

We need to record working hours for our staff on the Railway infrastructure as part of our compliance. I need a spreadsheet drawn up which records these. The first pic ("data input") is what our Operations manager creates for his own reference so he can send to the client and our personnel so they have the info required. The second pic is what I have to record once the timesheets come back from site with regards to working hours to make sure they..

a) Do not exceed 72 hours per week

b) Do not work more than 13 days in a row

c) No more than 14 hours door to door

I can review a, b and c above manually if needed but what I really need is that when the Operations manager creates his sheet, he can access the names of personnel via means of a pull-down menu which automatically pulls in their reference number and telephone number at the same time. Then, he can pick a "leaving home" time (24 hour clock in 15 minute in 15 minute intervals), "arriving home", "leaving site" etc etc. The week ends on a Sunday so will need a calendar pull down menu as well with every week end option as the Sunday. The data on the "data input" needs to look similar to the pic attached as this is Whatsapp'd to staff so they can read it easily.

Skills: Excel, Excel Macros, Excel VBA

See more: working hours component joomla, joomla working hours, working hours illustrator, working hours counter, working hours sri lanka, working hours graphic designer, working hours time counter, indesign count working hours, javascript countdown working hours, count working hours freelance, count working hours spss, working hours deals2buy, normal working hours creative writer, program working hours counter, normal part time working hours per week, japanese translation working hours

About the Employer:
( 0 reviews ) Stevenage, United Kingdom

Project ID: #29899214

33 freelancers are bidding on average £434 for this job

(236 Reviews)
(987 Reviews)
(395 Reviews)

(469 Reviews)
(298 Reviews)
(160 Reviews)

* MsEXCEL Payroll+Time programming and database expert. American English is my first and only language. Greetings UK from the USA.. {smile} Highly experienced (25+ years) MsACCESS/MsEXCEL/SQL/VBA/VB.Net Business Info More

£389 GBP in 7 days
(35 Reviews)

Can we do this in MS ACCESS 365 64bit with VB Script? It will given more user friendly and try to connect whatsapp too. Let me know your whatsapp. Hi Mr. Employer, I have a lot of experience in Access and I can do this More

£250 GBP in 6 days
(78 Reviews)
(24 Reviews)

✅ I am an Excel Expert ✅ Hi there! I’m expert on VBA, Macro, Nested Formula & Function, Data Validation, Conditional Formatting, Power Pivot, Graph and Chart, Dynamic Dashboard and Advanced Excel Automation related va More

£400 GBP in 5 days
(53 Reviews)

Hi, Greetings! ✅checked your project details : Recording working hours Attachments Working [login to view URL] Data [login to view URL] ✅Completed Time : 24 hours or your requirement deadline . I would like to work on your project an More

£250 GBP in 1 day
(52 Reviews)
(9 Reviews)

Hi, I am very good in Excel vba, macro, chart etc. if you want to see my excel skills i can share with you some of my work on excel. I understand the value of deadline and do not compromise on quality. I feel fit mysel More

£250 GBP in 1 day
(24 Reviews)

Hello Sir/Madam Ready to start now. I can do your project with 100% accuracy. I have reviewed your project brief carefully and would like to assist you with the task.I have 8 years experience of Excel macro virus task More

£500 GBP in 7 days
(59 Reviews)

Hi Good Day,Hope you are doing good. I can do this work.I am expert in Excel automation. I have 5+ years experience in [login to view URL] project completed in this site with 5 star rating.I will start working immediately. Look More

£250 GBP in 3 days
(57 Reviews)
(8 Reviews)

I will do it quickly. Recording Working hours. Hi i am an Senior Excel VBA/ Macros Expert. As 9+ years experiences in these field. I can give good quality work. I have read the guidelines of your work.I believe that More

£250 GBP in 2 days
(79 Reviews)

Hello, Sir. Expert of Excel VBA is here. I've gone through your project requirement and found my skill best suited in this one. I am familiar with technologies such as C++, VB, MS Office, Database Programming, Data Pro More

£250 GBP in 3 days
(15 Reviews)

Good Day! I am Arsenio Javier but you can call me Sen. I am a certified public accountant in the Philippines since 2011. As a freelancer, I offer Excel-related services which include assistance in Excel formulas, funct More

£750 GBP in 7 days
(2 Reviews)

i am a expert in data entry i have a special skill of excel and i am a honest and time concern person

£300 GBP in 5 days
(0 Reviews)