excel works and time sheets for project management

Hi I need to solve with some formula or VBA this Excel Sheet.

I have:

Start Date and Start Time

+ Days or Hours

= FInish Date and Finish Time

The point is that I need to take care about a specific timesheet (works hours and days) in order to make the right counting.

I here attach an example of the file.

In RED you find the RESULT that I need to generate by a formula considering the date and works time that are listed in the same sheet.

Please answer only if you solve the problem in the best way you can with FORMULAS or VBA and explain to me


Taidot: tietojenkäsittely, Excel, Visual Basic, Visual Basic for Apps

Näytä lisää: excel timesheet template with tasks, simple project plan template, free excel project management tracking templates, free project management templates excel 2007, project tracking template excel free download, multiple project tracking template excel, project management excel template, project management dashboard excel, project management php mysql time free, ready exciting time project management, freeware excel project management, time project management php mysql, project management excel, excel spreadsheet time management, Excel project management , part time project management, excel project management templates web design, excel sheets accounts management travel agencies, good ratio project management time, excel spreadsheets time management

Tietoa työnantajasta:
( 10 arvostelua ) Montebelluna, Italy

Projektin tunnus: #17653715

43 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön


Hi Mirco, I am good at Excel and vba. Looking forward to discuss in the chat. I have referred the file. There are works listed left side and right side few dates and times. Looking forward. -Chandra

$30 USD 0 päivässä
(807 arvostelua)

Hello Sir, I am the expert freelancer here. I am on the 6th position through out the world to deliver the quality job. I have deliver here more than 390 + projects with 100% client satisfaction. I can help you Lisää

$100 USD 2 päivässä
(304 arvostelua)

I have understood the calculation and I can achieve it using a macro. I have excellent command on MS Excel. I have completed complex projects in Excel before . For instance - Built a delivery schedule for pick-up Lisää

$30 USD 1 päivässä
(80 arvostelua)

Hello, I am proficient with Excel and VBA and I would love to help you with this task. Please contact me for more information.

$25 USD 1 päivässä
(136 arvostelua)

Hello there, I have done that in VBA and it auto-calculates and auto-populates the value sum whenever time value is entered. Thanks

$25 USD 1 päivässä
(80 arvostelua)

Normally the date and time is very challenge-able task in any computer language. Because if the date 30 (if month has 31 then it should be goes to 31 with time.) like this we have to work out that formula. Any have we Lisää

$30 USD 1 päivässä
(79 arvostelua)

Hi, Experienced Data Analyst and Macro Developer. I have read your instructions carefully. I have created vba for date calculation so have experience of this work. I checked your attached file and found some Lisää

$30 USD 1 päivässä
(72 arvostelua)
$30 USD 1 päivässä
(65 arvostelua)

Hello, I hope you are well. These are my strengths: Immediate availability. Responsible, fast and accurate. Full-time freelancer. Excel expert. 100% satisfaction guaranteed. Available to any help after com Lisää

$30 USD 0 päivässä
(31 arvostelua)

Hi, Price and duration is negotiable. I am expert in Excel having 12 Yrs Professional experience. I’ll complete task with 100% Accuracy and in least possible time. I assure you, you will be another 100% satis Lisää

$100 USD 1 päivässä
(18 arvostelua)

Dear Sir, I am Fady from Egypt. I can do it with a very high quality. I can start immediately with a low fixed price. My job success score is 100%. I am looking forward to hear from you soon. Thanks in advance, Lisää

$25 USD 1 päivässä
(6 arvostelua)

Hi micro, I can do these calculations in Excel. I am not fully expert in VBA so I can only do these calculations for hours and date in excel sheet as you required.

$40 USD 1 päivässä
(10 arvostelua)

Hellow Dere !! Thanks for taking the time to review my proposal! I’ve looked over your notes regarding your project i am Professional freelancer with expreince and education with relevant certification for proje Lisää

$25 USD 1 päivässä
(18 arvostelua)

Hi I am "VBA Developer". Expert in Web Scraping & VBA Macros.. Outlook Automation i can scrape any website.. & Python programming, Google Apps Script coding, Wordpress Developement, HTML, VB.Net I will do Lisää

$25 USD 1 päivässä
(13 arvostelua)

Dear sir, I can deliver your your requirement as you described.i have developed many excel vba applications and you can go through my reviews and see how clients are satisfied about my delivery.i’ll customize this as y Lisää

$13 USD 3 päivässä
(4 arvostelua)

Hi. You want to get reconciled date and time of the work beginning + duration with your timetable. I can do the task without VBA, just using formulas. If you need something else, I'll do it with pleasure. Hope for our Lisää

$10 USD 1 päivässä
(3 arvostelua)

Hello, I have experience in creating macros vba and entering data in Excel for more than 7 years. I assure you an excellent job, I will not disappoint you. If you want to work with me, do not hesitate to contact me.

$13 USD 1 päivässä
(3 arvostelua)

Hey there. I request you a brief read my 2 minutes, please :) I'm new at freelancer and therefore have low rating. In order to build my rating and prove my expertise, i'm willing to work for your project are bare m Lisää

$20 USD 1 päivässä
(1 arvostelu)

Hi Sir I’m a new freelancer so I am happy to do it at minimal cost or even for free in exchange for positive feedback Regards

$10 USD 3 päivässä
(5 arvostelua)

Hi, This is Gopal. I am an accountant. I have gone through your project description and understood. Kindly note that I have been working in Accounting, Tax, Audit and Finance function for more than 5 years. Hen Lisää

$25 USD 1 päivässä
(3 arvostelua)