software

I'm looking for a function that calculate the total amount of hours
between to time-stemps BUT only the working hours (office-hours 09:00
to 17:00)
For workings days there is a function quot;networkdaysquot; but I'm looking for
such a function but then for hours.--
JSE
------------------------------------------------------------------------
JSE's Profile: www.excelforum.com/member.php...oamp;userid=33030
View this thread: www.excelforum.com/showthread...hreadid=528507See if Chip Pearson's page about working hours has what you want

www.cpearson.com/excel/datetime.htm#WorkHours
quot;JSEquot; wrote:

gt;
gt; I'm looking for a function that calculate the total amount of hours
gt; between to time-stemps BUT only the working hours (office-hours 09:00
gt; to 17:00)
gt; For workings days there is a function quot;networkdaysquot; but I'm looking for
gt; such a function but then for hours.
gt;
gt;
gt; --
gt; JSE
gt; ------------------------------------------------------------------------
gt; JSE's Profile: www.excelforum.com/member.php...oamp;userid=33030
gt; View this thread: www.excelforum.com/showthread...hreadid=528507
gt;
gt;


If you have a start time/date in A2 and an end time/date in B2 you can
calculate the working hours between them with this formula

=(NETWORKDAYS(A2,B2)-1)*(quot;17:00quot;-quot;09:00quot;) MOD(B2,1)-MOD(A2,1)

format as [h]:mm

note: the above is only guaranteed to work if your quot;time stampsquot; are
within working hours, post back if not, you'll need a more complex
formula.....--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: www.excelforum.com/member.php...oamp;userid=30486
View this thread: www.excelforum.com/showthread...hreadid=528507