tracking business time elapsed

[coooop]

I need to track the business days and hours between two dates. I foun
a formula using networkdays but I can't get it to work. If anyone ca
help, I would appreciate it. Thanks in advance

 

[Niek Otten]

Visit

http://www.cpearson.com/excel/DateTimeWS.htm#WorkHours

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

 

[Norman Harker]

Hi coooop!

NETWORKDAYS gives number of working days between two dates inclusive
of those two dates (if they are working days).

Providing you have a full number of hours on the starting date and
ending date, to get the number of hours, just multiply the days
returned by NETWORKDAYS by the number of working hours per day.

So:
A1:
30-Jan-2004
B1:
10-Feb-2004
C1:
=NETWORKDAYS(A1,B1)
Returns 8
D1:
=C1*7.5
Returns:
60

With NETWORKDAYS you also get the optional third argument that allows
you to specify a range containing holiday dates which are also
excluded from the day count.


--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Fred Smith]

The function Networkdays is in the Analysis Toolpak. Use Tools>Add-ins to
install it.

 

[coooop]

I used the formula at cpearson.com, works great. I was trying to use it
before but my formatting was causing an error message. Date serials
were off. Works now.