Counting Time

L

littlejess22

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
 
R

Rick Rothstein \(MVP - VB\)

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
 
T

Teethless mama

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
 
L

littlejess22

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

littlejess22
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top