Counting Time

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

littlejess22 - 12 Jun 2007 14:43 GMT

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

Reply to this Message

Rick Rothstein (MVP - VB) - 12 Jun 2007 15:03 GMT

> How can I count, in hours; time elapsed in the form dd/mm/yyy hh:mm
> between
[quoted text clipped - 6 lines]
> break
> down into hours.

This seems to work...

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

Rick

Reply to this Message

Teethless mama - 12 Jun 2007 15:31 GMT

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

> > How can I count, in hours; time elapsed in the form dd/mm/yyy hh:mm
> > between
[quoted text clipped - 10 lines]
>
> =24*((B4-A4)-NETWORKDAYS(A4,B4))

> Rick

Reply to this Message

littlejess22 - 12 Jun 2007 16:00 GMT

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

littlejess22

> your formula fails on other dates.
>
[quoted text clipped - 24 lines]
>
> > Rick

Reply to this Message