LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
LEG LEG is offline
external usenet poster
 
Posts: 16
Default How many days in a row does an employee work within a 2 month peri

Hi!
In my worksheet I have in coloumn A employees and in coloumn C and forward I
have every day in a two month period. F.eks. 1. november to 31. december (61
coloums in all). In each cell there is either a blank cell og a no. which
represents the no. of hours they worked that day.

I need a formula/macro/VBA ... which tells me how many days in a row each
employee had in the two month periode.

Any help would be great.

--
LEG-denmark
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Employee days worked (-Holidays, -weekends, Snow Days, etc) Denise Excel Discussion (Misc queries) 2 December 31st 08 04:37 PM
Calulating the number of days an employee works Curtis Excel Worksheet Functions 6 October 30th 06 09:43 AM
Number of work days/month Vanna Excel Worksheet Functions 1 March 16th 06 04:35 AM
Counting the days worked in a month by employee Curtis Excel Worksheet Functions 0 November 8th 05 05:15 PM
HOW CAN I FILL AN EMPLOYEE CARD WITH EXACT DAYS CALENDAR LARGO16 Excel Worksheet Functions 0 January 19th 05 12:41 PM


All times are GMT +1. The time now is 08:21 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"