RE: $$Excel-Macros$$ Count Based on Date & Time

[Krishnaraddi V. Madolli]

I want count of how many assigned on that particular day based on Date Assigned 
column in second sheet but time should be between 7:30AM to 5:00 PM to take 
count of that day.

Ex: how many assigned on 6th August between 7:30AM to 5:00 PM, if date is 6th 
and time is above 5 PM then it should come in 7th August data.

Regards,

Krishnaraddi V Madolli.
Data Analytics Team
Sedgwick Claims Management Services, Inc.
Xchanging Towers, SJR iPark,
EPIP Area, Whitefield
Bangalore - 560 066. India.
Direct Line: +1.800.920.9657 Extn 1915
Switchboard: +90-(0)80-30540000 Extn 1915
Email: 
krishnaraddi.mado...@asia.xchanging.com<mailto:krishnaraddi.mado...@asia.xchanging.com>
krishnaraddi.mado...@sedgwickcms.com<mailto:krishnaraddi.mado...@sedgwickcms.com>
www.sedgwickcms.com<https://outlook.us.xchanging.com/exchweb/bin/redir.asp?URL=http://www.sedgwickcms.com>
 |  The leader in innovative claims and productivity management solutions

Success is never permanent, Failure is never final, so always do not stop 
effort until your victory makes a history.
[http://images.coolchaser.com/themes/t/404137-i311.photobucket.com-albums-kk467-volleycutiegirl-icon.png]Please
 consider the environment before printing this message

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On 
Behalf Of Kuldeep Singh
Sent: 08/20/2012 16:25
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Count Based on Date & Time


Hi,

Kindly more explain.

Regards,
Kuldeep Singh
On Mon, Aug 20, 2012 at 4:16 PM, Krishnaraddi V. Madolli 
<krishnaraddi.mado...@asia.xchanging.com<mailto:krishnaraddi.mado...@asia.xchanging.com>>
 wrote:

"CONFIDENTIALITY NOTICE: This message and any attachment are confidential and 
may also be privileged. If you are not the intended recipient of this e-mail 
you may not copy, forward, disclose or otherwise use it or any part of it in 
any form whatsoever. If you are not the intended recipient please telephone or 
e-mail the sender and delete this message and any attachment from your system."
--
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5) Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited.

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
---
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to 
excel-macros@googlegroups.com<mailto:excel-macros@googlegroups.com>.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com<mailto:excel-macros+unsubscr...@googlegroups.com>.


-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

<<inline: image001.png>>