network hours

Hi there, I am needing help on a formula to calculate the working hours between two date/time stamps - less weekends and holidays that I define. I have searched threads for days and cannot get it to work. Working Hours (EST): 8:00am - 10:00pm Weekends: Saturday & Sunday Holiday: Sheet 1, Column...

Hi Everyone, I have been trying to get this sorted for a while but no luck. I have a spreadsheet (obviously), i have several hidden columns which automatically capture the time and date that certain cells are populated. I want to subtract the difference between two of these cells as it will...

Hi Everyone, I have been trying to get this sorted for a while but no luck. I have a spreadsheet (obviously), i have several hidden columns which automatically capture the time and date that certain cells are populated. I want to subtract the difference between two of these cells as it will...

Hi Team, I currently have a formula which works out the number of hours passed between a particular date and Now, i really need this to be worked out in business hours much like =networkdays, can anyone please provide me with some help on how to achieve this. below is the formula i am...

I have the below Date & time in cell a1 and another date and time in cell a3 8/2/2010 08:45:00 8/2/2010 10:15:00 I need to be able to show duration (in hours) between the 2 times, in this instance its the same date, but this wont always be the case. To add a level of complexity in addition...