Thread: Counting Time
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rick Rothstein \(MVP - VB\) Rick Rothstein \(MVP - VB\) is offline
external usenet poster
 
Posts: 2,202
Default 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