Sorry jacob

it works out the correct number of days how do i calculate the amount of
hours worked er day by the number of days
IE 01/08/09 to 15/08/09= 10 working days* 7.4 (where 7.4 is hours worked and
..4 percentage of hour worked) should equal 74

???

"Jacob Skaria" wrote:

With start date in cell A1 and end date in cell B1 try the below formula
which use WEEKDAY and MIN functions...Format the formula cell to general if
it turns out to be in date format

=(B1-WEEKDAY(B1,2)+WEEKDAY(A1,2)-A1)/7*5-MIN(5,WEEKDAY(A1,2))+MIN(5,WEEKDAY(B1,2))

If this post helps click Yes
---------------
Jacob Skaria


"Gibbyky2" wrote:

here goes

i use excel 2007 and can calculate number of days between 2 dates using
networkdays function. but my colleagues use older versions of excel and
networkdays function does not work

i want to work out the example below as an example

1st date = 09/10/09
2nd date = 23/10/09

this equals 10 working days, i then want to be able to calculate the number
of days by 7.4 (average hours worked per day)

many thanks