Help with Dates

[jedibrown]

Good afternoon.

I am looking for a formula which gives the amount of working hours between 2 dates. Working hours are monday - Friday and 10am - 6pm

Any help would be very much appreciated.

Thanks

 

[davesweep]

Hi,

This should give you what you require, where A2 is the start date and A1 is the end date

=NETWORKDAYS(A2,A1)*8

See the help file for more details on =NETWORKDAYS()

 

[jedibrown]

Hi - thanks for this.

I was hoping to be able to get the amount of working hours rather than days. Is this possible?

Thanks again.

 

[jedibrown]

Apologies - my error! This works perfectly. Thank you.