|
|
|
|
#1
01-19-2012, 01:07 PM
|
|||
|
|||
A1 = received date
B1 = completed date C1: =MAX(0.5, INT(B1)-INT(A1)) Format C1 as General. |
|
#2
01-19-2012, 02:10 PM
|
|||
|
|||
|
Awesome! Thank you!
I don't understand it but it works like a charm! |
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Formula to calculate Leap Year | USAOz | Excel | 2 | 09-11-2011 04:58 PM |
 Calculate elapsed time in Word table?
|
Snvlsfoal | Word Tables | 1 | 08-11-2011 05:42 AM |
|
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 |
|
How to get cells to calculate time?
|
jrasche2003@yahoo.com | Excel | 2 | 02-09-2007 07:10 AM |
Windows XP 
Office 2003
Hybrid Mode