Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #7  
Old 07-05-2012, 03:40 PM
Colin Legg's Avatar
Colin Legg Colin Legg is offline Need a formula to calculate turnaround time Windows 7 32bit Need a formula to calculate turnaround time Office 2010 32bit
Expert
 
Join Date: Jan 2011
Location: UK
Posts: 369
Colin Legg will become famous soon enough
Default

Hi,

If A1 contains 7/6/12 10:22
and A2 contains 7/3/12 14:13

Then put this formula in A3
=A1-A2

and format A3 to show both the date and time.
 



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 07:47 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