"workinghours"

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JSE - 31 Mar 2006 13:32 GMT

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

Reply to this Message

Duke Carey - 31 Mar 2006 13:49 GMT

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

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

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

Reply to this Message

daddylonglegs - 31 Mar 2006 20:48 GMT

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

Signature

daddylonglegs

Reply to this Message