Thread: Counting Time
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
littlejess22 littlejess22 is offline
external usenet poster
 
Posts: 8
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.

Any advice would be very much appreciated.

Thanx