Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page Need a formula to calculate turnaround time
Register FAQ

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 01-19-2012, 01:07 PM
JBeaucaire JBeaucaire is offline Need a formula to calculate turnaround time Windows XP Need a formula to calculate turnaround time Office 2003
Advanced Beginner
  
Join Date: Dec 2011
Posts: 51
JBeaucaire is on a distinguished road
Default
A1 = received date
B1 = completed date

C1: =MAX(0.5, INT(B1)-INT(A1))
Format C1 as General.
 

« Previous Thread | Next Thread »


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula to calculate Leap Year USAOz Excel 2 09-11-2011 04:58 PM
Need a formula to calculate turnaround time Calculate elapsed time in Word table? Snvlsfoal Word Tables 1 08-11-2011 05:42 AM
Need a formula to calculate turnaround time What formula should I use to calculate commission? grs Excel 3 02-21-2011 02:17 AM
Calculate formula base of list menu rkeles Excel 4 09-22-2010 12:38 AM
Need a formula to calculate turnaround 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:41 PM.

Contact Us - Privacy Statement - Top

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