Microsoft Office Forums - View Single Post - Need a formula to calculate turnaround time

Thread: Need a formula to calculate turnaround time

View Single Post

Old

01-19-2012, 01:07 PM

JBeaucaire JBeaucaire is offline

JBeaucaire is offline

JBeaucaire uses Windows XP

Windows XP JBeaucaire uses Office 2003

JBeaucaire uses Office 2003

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.