"workinghours"
 

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) :confused:
For workings days there is a function "networkdays" but I'm looking for
such a function but then for hours.


--
JSE
------------------------------------------------------------------------
JSE's Profile: http://www.excelforum.com/member.php...o&userid=33030
View this thread: http://www.excelforum.com/showthread...hreadid=528507

"workinghours"
 

See if Chip Pearson's page about working hours has what you want

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



"JSE" wrote:


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) :confused:
For workings days there is a function "networkdays" but I'm looking for
such a function but then for hours.


--
JSE
------------------------------------------------------------------------
JSE's Profile: http://www.excelforum.com/member.php...o&userid=33030
View this thread: http://www.excelforum.com/showthread...hreadid=528507

"workinghours"
 

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)*("17:00"-"09:00")+MOD(B2,1)-MOD(A2,1)

format as [h]:mm

note: the above is only guaranteed to work if your "time stamps" are
within working hours, post back if not, you'll need a more complex
formula.....


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=528507