total time elapsed between two dates

[hemasundar]

sir,
i need formula to calculate total time between two dates
here i am explaining my criteria with an example
from 25/10/2013 19:00 to 27/10/2013 07:30

condition 1. between 06:00 to 18:00 treat as peak hours
condition 2. between 18:01 to 05:59 treat as slack hours

how many peak hours and how many slack hours
total time = total slack hours + total peak hours

 

[Luke M]

Does this article help?
http://chandoo.org/wp/2010/09/10/working-hours-formula/
You can find the working (peak time), and then the slack time is the difference between total time and peak time.