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
|