Suljettu

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

Mirco

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:
( 8 arvostelua ) Montebelluna, Italy

Projektin tunnus: #17653715

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

cgullapalli

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ä
(766 arvostelua)
7.8
schoudhary1553

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ä
(282 arvostelua)
7.6
archanaoswal

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ä
(72 arvostelua)
5.7
vlayausa

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ä
(133 arvostelua)
5.8
royalcalif

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ä
(73 arvostelua)
5.3
supper5guy

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ä
(55 arvostelua)
5.0
vsprybhanu

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ä
(68 arvostelua)
5.3
$30 USD 1 päivässä
(34 arvostelua)
5.0
jasalaz100

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ä
(25 arvostelua)
4.7
Mfaisalshahzad00

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)
3.9
arslantahir87

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ä
(16 arvostelua)
3.9
nbprince

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ä
(7 arvostelua)
3.3
FadyMakar

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ä
(5 arvostelua)
3.3
dataexplorer

Hi, Yes, I can work for you as per your project description with amazing exploration and experimental research abilities of mine is perfect for excel expert that you may require. My work fulfills as well as keep you r Lisää

$25 USD 1 päivässä
(10 arvostelua)
3.1
nishantha041

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ä
(3 arvostelua)
2.7
josermarinr18

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ä
(2 arvostelua)
2.1
Mokshith30

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ä
(5 arvostelua)
2.3
axiaer

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)
1.6
stanleyw12

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)
1.7
absetiawan

Do you really need an vba workbook? If the result is simpler with formula, I will give you both version.

$25 USD 1 päivässä
(0 arvostelua)
0.0