View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] emile.asberg@gmail.com is offline
external usenet poster
 
Posts: 3
Default Calculate elapsed time excluding specific timeframe

Mick,

Again thanks for your help.

It not quite want i need yet. For longer periods (24 hrs) it works fine.

I want to calculate only the hours used between 0500 - 2200
When i use above times on the same date the result should be 17. It now gives 10 as a result.

Emile