Thread: [Solved] Need a formula to calculate turnaround time
View Single Post
 
Old 07-05-2012, 03:40 PM
Colin Legg's Avatar
Colin Legg Colin Legg is offline Windows 7 32bit 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.