LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 10
Default Annual leave - list days off

Help! (please)

I've looked at using INDEX & MATCH etc for these but can't quite get what I want.

I have a list of staff's leave each month, set out as below. Members of staff do not always work the same number of hours, so a day off is denoted as their number of hours, so below this is 7.5. I need to have a function/formula that returns which days a person has had off. For example in the sample below I would like a result of "Mon 01 Feb 16, Wed 03 Feb 16, Tue 09 Feb 16." It wouldn't matter if these results were in individual cells as I could concatenate.

As a refinement (and if I'm not asking too much) if someone has a half-day it's denoted as 3.75 - could we cater for that too?

Col C Col D
Row 1 Employee/Date Hours per days
row 2 John Mills
row 3
row 4 Mon 01 Feb 16 7.5
row 5 Tue 02 Feb 16
row 6 Wed 03 Feb 16 7.5
row 7 Thu 04 Feb 16
row 8 Fri 05 Feb 16
row 9 Sat 06 Feb 16
row 10 Sun 07 Feb 16
row 11 Mon 08 Feb 16
row 12 Tue 09 Feb 16 7.5
row 13 Wed 10 Feb 16
row 14 Thu 11 Feb 16
row 15 Fri 12 Feb 16



Thanks in advance!

Steve
 
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
Annual Leave Summary Tia[_3_] Excel Discussion (Misc queries) 2 March 26th 08 09:48 AM
Annual leave [email protected] Excel Discussion (Misc queries) 3 March 12th 08 02:20 PM
Annual Leave Planner peter Excel Discussion (Misc queries) 1 November 1st 06 10:17 AM
Annual Leave Aussie Peter Excel Discussion (Misc queries) 1 January 31st 06 03:25 AM
Tracking annual leave opos New Users to Excel 4 August 15th 05 11:09 AM


All times are GMT +1. The time now is 10:43 AM.

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"