troubleshooting Question

Excel formula required that calculates the total time from start to finish for each date period

Avatar of Steve B
Steve BFlag for Australia asked on
Visual Basic ClassicMicrosoft ExcelVB Script
2 Comments1 Solution1381 ViewsLast Modified:
I have a spreadsheet that is used to calculate different jobs that my staff do as chauffeurs.

What I would like is a formula that looks at the date column, then the start column for the time work started then finds the row that contains the last input of that date and the finish time and calculates the number of hours on the job.

The thing is that on the spreadsheet there are multiple dates, so it would need to search and find the start and finish time of each date on the spreadsheet and calculate the number of hours on the job for each date, showing the total amount of time on the job for that particular spreadsheet (or the work shown on the spreadsheet).  

The total amount of hours should be shown in the format of [h}:mm and be displayed in cell AB6.

One spreadsheet would normal have about 150 plus jobs on it, over a 15 day period.  So we would use about 150 rows starting from Row A13.

Also, please do not convert or save the spreadsheet in xlsx.  Most of my workers still use the xls format.


For privacy reasons I have remove the prices and Client Names from the spreadsheet.
COPY-Chauffeur-SpreadSheet-Invoi.xls
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 2 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros