Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #3  
Old 05-18-2015, 04:45 AM
ballst ballst is offline Macro needed for time calculation and auto insert Windows XP Macro needed for time calculation and auto insert Office 2003
Advanced Beginner
Macro needed for time calculation and auto insert
 
Join Date: Dec 2014
Posts: 32
ballst is on a distinguished road
Default

Quote:
Originally Posted by NoSparks View Post
Ballst, with row 2 being empty, is it reasonable to think you want a blank line above each "NEWCASE" line ?

What is the correct Time Taken result that should be in cell C13 ...... 26 hours 8 minutes 54 seconds ?

What would the end point be for NEWCASE ---> LON/00AM/OLR/2014/0558
that starts on your line 952 ?
Hi NoSparks, thanks for the reply.

A blank line looks neat & would help define each task, so could be useful.

You are right that the correct time should be 26+ hours, I changed the time as my original sum calculation returned it as an error, so did 'cheat' and make a change.

For NEWCASE ---> LON/00AM/OLR/2014/0558 the end point would be
Critical Information Missing. Move on to Notify Parties Incomplete Application Received.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro needed for time calculation and auto insert Preventing Auto Metadata - Help Needed! samcmakin Word 1 04-09-2015 11:48 PM
Macro needed for time calculation and auto insert How to prevent the auto-calculation of the '% Complete' field in MS Project Professional 2013? VivekG1 Project 1 02-06-2015 05:33 AM
'Monday to Friday' Date calculation help needed ballst Word 10 12-16-2014 09:51 AM
Macro Needed to bold specific lines and Macro to turn into CSV anewteacher Word VBA 1 05-28-2014 03:59 PM
Macro needed for time calculation and auto insert Macro Needed to Insert Asnwer to A Question in Multiple Choice Format Question rsrasc Word VBA 7 03-28-2014 12:28 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:31 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft