"workinghours"

J

JSE

I'm looking for a function that calculate the total amount of hour
between to time-stemps BUT only the working hours (office-hours 09:0
to 17:00) :confused:
For workings days there is a function "networkdays" but I'm looking fo
such a function but then for hours
 
D

daddylonglegs

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.....
 
Top