View Single Post
 
Old 02-11-2011, 03:11 AM
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

Assume the start date and time is in A1 and the end date and time is in B1, put this formula in C1 and format the cell as [hh]:mm
Code:
=NETWORKDAYS(A1,B1)-1-MOD(A1,1)+MOD(B1,1)
Using the numbers in your example this formula returns 21:00

Hope that helps...
Reply With Quote