View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
vezerid vezerid is offline
external usenet poster
 
Posts: 751
Default Time Lapse Calculation

Tony,

Therefore, if a ticket is logged at 5:25 PM on Monday and completed at 8:00
AM Tuesday the NETWORKDAYS is 2.


What would you like in this case? 0 days and 14:35 hours?

Also, is there a chance that date/time started/ended are holidays? Or
will they always be workdays?

Kostis Vezerides