
Closed
Posted
Paid on delivery
My current Salesforce report lists every user’s first login, final logout, and each time they punch a break. What it still lacks is the math behind it. I need row-level and summary formulas that: • show each agent’s total staff time (logout – login minus all breaks) • break out the total minutes spent on breaks • keep the original first-login and final-logout times visible for reference The tricky part is our weekend night shifts. An agent can log in late Saturday night, work past midnight, and clock out early Sunday. The same happens on Sunday into Monday. Your formulas must handle this overlap cleanly, attributing hours to the correct shift without double-counting or dropping minutes at midnight. I work entirely inside the standard Salesforce Report Builder (no external ETL), so everything has to be delivered as formula expressions or clear step-by-step instructions I can paste into the report fields. A quick example on a small data set will be enough for me to validate the logic. Timing: I’d like this turned around within a day, so please take the job only if you have immediate availability. Once the formulas return the correct totals for a sample Saturday/Sunday night shift and a normal weekday shift, the task is complete and the milestone can be released.
Project ID: 40621280
6 proposals
Remote project
Active 6 days ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
6 freelancers are bidding on average ₹9,108 INR for this job

With my results-driven mindset and wide range of skills, I am confident that I can deliver the Salesforce Shift Time Formulas you seek. My exceptional proficiency in Data Analysis and Excel makes me a perfect fit for your project. Over my career, I have developed and optimized various complex formulas to deal with data overlaps, and can bring this expertise to create row-level and summary formulas according to your unique requirements. Pitching in my experience in Business Analysis and Report Writing, I understand the criticality of maintaining accuracy in your Salesforce report. I assure you zero double-counting or drop of crucial minutes at midnight. My deliverables will be formula expressions or step-by-step instructions you can readily use within the standard Salesforce Report Builder - easing your burden. My immediate availability allows me to deliver within your desired timeframe of a day without compromising on the quality. Moreover, as a professional who values client satisfaction above everything, I provide unlimited revisions until we achieve the perfect result for your project. With Naresh on board, you get top-quality service, prompt delivery and a reliable resource that aligns fully to your requirements. Discernment is guaranteed!
₹5,050 INR in 1 day
6.4
6.4

Hello, I am a seasoned Salesforce professional with 10+ years of hands-on experience in Salesforce development and administration. Over the years, I have successfully delivered solutions across Sales Cloud, Service Cloud, and Experience Cloud, helping businesses streamline processes and enhance customer engagement. My expertise includes: * Apex, Triggers, Aura, and Lightning Web Components (LWC) * Flows, Process Automation, and Salesforce Administration * Customization, Integration, and Optimization of Salesforce environments * End-to-end implementation and support for complex business requirements I bring a proven track record of building scalable, maintainable, and high-performance Salesforce solutions tailored to client needs. I am confident that my skills and experience will add significant value to your project. Looking forward to collaborating and contributing to your success. Best regards, Arpit K.
₹5,000 INR in 1 day
3.5
3.5

This project immediately caught my attention because it is exactly the type of work I do best. Your need for row-level and summary formulas to calculate total staff time and handle weekend night shifts without double-counting is clear. I understand the importance of delivering clean, professional, and seamless formulas that integrate smoothly into your Salesforce Report Builder. While I am new to freelancer, I have tons of experience and have done other projects off site, including automating complex reports and crafting user-friendly solutions. If this sounds like what you're looking for I'd love to hear more about your project. Regards, Warrick Van Eeden
₹700 INR in 7 days
0.0
0.0

Hi, I have immediate availability and can deliver this within your one day turnaround. I am a Salesforce developer with 10+ years of experience and I work with Salesforce Report Builder formulas regularly, including time calculations that span midnight for overnight shifts. I will write row level formulas for total staff time (logout minus login minus all breaks), total break minutes, and keep your login and logout columns visible for reference. The midnight overlap logic for Saturday into Sunday and Sunday into Monday shifts will be handled cleanly with no double counting or dropped minutes. I will include a sample data walkthrough covering both a normal weekday shift and an overnight weekend shift so you can validate everything before applying it to your live report. Everything will be delivered as paste ready formula expressions or step by step instructions for Report Builder only. Ready to start right now. Message me and I will get it done today. Best regards Ritik Wasekar
₹900 INR in 1 day
0.0
0.0

Pune, India
Member since Aug 2, 2026
€125-250 EUR
₹600-1500 INR
₹1500-12500 INR
$30-250 USD
₹750-1250 INR / hour
$250-750 USD
$750-1500 USD
$30-250 USD
$30-250 USD
$15-25 USD
₹37500-75000 INR
$15-20 USD
€250-750 EUR
₹1500-12500 INR
$1500-3000 USD
₹1500-12500 INR
$8-15 USD / hour
$2-8 USD / hour
₹750-1250 INR / hour
₹600-1500 INR