Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-10-2017, 07:55 AM
StephenRay StephenRay is offline Calculate document completion time Windows 7 64bit Calculate document completion time Office 2010 64bit
Advanced Beginner
Calculate document completion time
 
Join Date: Jan 2012
Location: Overland Park, Kansas
Posts: 53
StephenRay is on a distinguished road
Default

GMaxey, This calculation between two dates is working great. Others may be interested to see what the output looks like:
It took this long: 1 day, 22 hours, 27 minutes and 30 seconds. Thursday, August 10, 2017 9:48:13 AM



But usually, I get something like this:
It took this long: 10 minutes and 15 seconds. Thursday, August 10, 2017 9:45:49 AM

The date that it subtracts from looks something like this: 8/8/2017 11:20:42 AM
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Calculate time over two dates Diver Excel 3 07-22-2017 11:31 PM
Calculate document completion time how to calculate average time aymanharake Excel 6 02-17-2017 04:22 PM
Calculate Time in Hours and Percent pabyford Excel 6 12-13-2016 12:29 PM
Calculate document completion time Formula To Calculate Countdown Days To Project Completion Catherine Project 1 02-19-2014 11:15 AM
Calculate document completion time How to get cells to calculate time? jrasche2003@yahoo.com Excel 2 02-09-2007 07:10 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:40 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