Counting Time
 

How can I count, in hours; time elapsed in the form dd/mm/yyy hh:mm between
two dates and times and not include none working days?

i.e 08/06/2007 10:00 to 11/06/2007 09:00 should be 23 hours.

I use NETWORKDAYS frequently and am tring to figure something out along
those lines, but that only returns a whole number and I can't get it to break
down into hours.

Any advice would be very much appreciated.

Thanx

Counting Time
 

How can I count, in hours; time elapsed in the form dd/mm/yyy hh:mm
between
two dates and times and not include none working days?

i.e 08/06/2007 10:00 to 11/06/2007 09:00 should be 23 hours.

I use NETWORKDAYS frequently and am tring to figure something out along
those lines, but that only returns a whole number and I can't get it to
break
down into hours.

This seems to work...

=24*((B4-A4)-NETWORKDAYS(A4,B4))

Rick

Counting Time
 

your formula fails on other dates.

=24*((B4-A4)-NETWORKDAYS(A4,B4))

start date: 6/8/2007 10:00
end date: 6/13/2007 9:00
your result is 23 it should be 71 hours

The formula below should work for you

=(NETWORKDAYS(A1,B1,holidays)-1+MOD(B1,1)-MOD(A1,1))*24


"Rick Rothstein (MVP - VB)" wrote:

How can I count, in hours; time elapsed in the form dd/mm/yyy hh:mm
between
two dates and times and not include none working days?

i.e 08/06/2007 10:00 to 11/06/2007 09:00 should be 23 hours.

I use NETWORKDAYS frequently and am tring to figure something out along
those lines, but that only returns a whole number and I can't get it to
break
down into hours.

This seems to work...

=24*((B4-A4)-NETWORKDAYS(A4,B4))

Rick

Counting Time
 

Absolutley Bloody fantastic. Thank you so much for the formula and speedy
response. cheers dudes.

littlejess22

"Teethless mama" wrote:

your formula fails on other dates.

=24*((B4-A4)-NETWORKDAYS(A4,B4))

start date: 6/8/2007 10:00
end date: 6/13/2007 9:00
your result is 23 it should be 71 hours

The formula below should work for you

=(NETWORKDAYS(A1,B1,holidays)-1+MOD(B1,1)-MOD(A1,1))*24


"Rick Rothstein (MVP - VB)" wrote:

How can I count, in hours; time elapsed in the form dd/mm/yyy hh:mm
between
two dates and times and not include none working days?

i.e 08/06/2007 10:00 to 11/06/2007 09:00 should be 23 hours.

I use NETWORKDAYS frequently and am tring to figure something out along
those lines, but that only returns a whole number and I can't get it to
break
down into hours.

This seems to work...

=24*((B4-A4)-NETWORKDAYS(A4,B4))

Rick