Turn Around Time Formula - Holidays & Weekends are NA

[ShannieD]

I need to calculate the difference between dates. Currently I'm using the DATEDIF formula based on the number of days between the two dates; however, I now need to show this information in hours and minutes.

Date Rec'd = 11/3/2010 3:05:59 PM
Date Assigned = 11/5/2010 9:47:09 AM
TAT to assign work = ?? (need new formula) current formula = 2 Days (not exact)

Current formula is =DATEDIF(A1,B1,"d")

Note, weekends and holidays are not applicable. Any assistance is greatly appreciated!

 

[Scott Huish]

DATEDIF for a day difference calculation is unnecessary, just subtract the dates: =B2-A2

Which should work for this scenario as well.

Format result as [h]:mm

Excel Workbook
	A	B	C
1	Date Rec'd	Date Assigned
2	11/3/2010 3:05 PM	11/5/2010 9:47 AM	42:41
Sheet7

 

[BeingYogi]

may be :

change cell format to

d hh:mm:ss

 

[Scott Huish]

d will limit it to 31 days max.

 

[ShannieD]

Thanks all for your help. I greatly appreciate it!