Counting Time
How can I count, in hours; time elapsed in the form dd/mm/yyy hh:mm
between
two dates and times and not include none working days?
i.e 08/06/2007 10:00 to 11/06/2007 09:00 should be 23 hours.
I use NETWORKDAYS frequently and am tring to figure something out along
those lines, but that only returns a whole number and I can't get it to
break
down into hours.
This seems to work...
=24*((B4-A4)-NETWORKDAYS(A4,B4))
Rick
|