Duration Between Time-stamps Report Automation in Excel
$10-30 USD
Paid on delivery
I'm looking for an expert who can help me streamline the process of time-stamp duration reporting in Excel. The solution I'm seeking should ideally have the following components:
I have a report (excel-sheet) exported from a system that I use in a weekly basis, however in this report, the date and time of processing exported in a form of “timestamp” and in order to calculate elapsed time of each stage in cycle, every time I have to do the followings:
- Fix the format issue in excel since system always export data in a form of “timestamp” and there is no to fix that.
- Exclude non-working hours for each stage/ elapsed time.
- Exclude Weekends (Friday & Saturday).
- Sum up the total of elapsed times
Do you have a solution that I can use the as tool either by creating excel Macro or Power BI, etc that I can use by uploading or copy paste exercise?
Note // please I’m not looking for a one-time report or fixing the uploaded files
Excell File attached 3 sheets (1- the exact report exported 2- report exported with expected results explained 3-Highlights)
The ideal candidate should have a proven track record of working with similar projects, possess advanced skills in Power BI and Excel Macro, and be able to deliver a streamlined solution that not only automates the duration process but also can easily be understood and utilized by others.
Project ID: #38031281
About the project
Awarded to:
20 freelancers are bidding on average $33 for this job
Hi, I specialize in creating streamlined solutions for time-stamp duration reporting in Excel Leveraging advanced Excel Macro skills, I can develop a customized tool that addresses your specific needs. This tool will a More
Hello, I understood that you need a reusable tool that you can use anytime to get the required output report automatically, I know what is the challenges and how to get the required report form the raw exported data as More
Hey aabarrak, I have carefully read through your project description regarding the automation of time-stamp duration reporting in Excel. I understand that you are looking for a solution that can streamline the process More
Hello, Kindly consider initiating a CHAT to transform your aspirations into tangible reality, as I am eager to delve into the intricacies of your project and collaborate effectively to achieve your desired outcome. For More
Hi I have read the requirements and understand them. I can assure you that if you work with me once, you will always work with me on these kinds of projects. would you like to discuss the project with me?
InstantQuality─── ⋆⋅☆⋅⋆ ── I am a specialized Master's degree holder equipped to tackle writing across various subjects. My commitment to work is unwavering, ensuring TOP RATED EXPERT delivers consistent and high-qua More
Hello, Since you mention Power BI as one of the tools required, it is possible to extract the timestamps and using Power BI Measures apply the formulas to get the "Stage Elapsed Time". Does help, if we can get on a ca More
Hello there! I am a Power BI developer with over 2 years of experience working with esteemed clients such as Bunge Limited, Veolia UK, etc. creating dashboards of varying complexities and requirements. If you think som More
