• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 89
  • Last Modified:

Excel 2013 how to Get the earliest time per day user wise

Hi,

I have a requirement for getting the earliest time a user has entered the office on a per day basis. Is there a pivot that can do the same. Attached is the sample excel sheet.

Please help.
USer-Attendece-.xlsx
0
GulfIT
Asked:
GulfIT
1 Solution
 
Rob HensonFinance AnalystCommented:
See attached.
USer-Attendece-.xlsx
0
 
Rgonzo1971Commented:
HI,

Is that what you are looking for?

Regards
USer-AttendeceV1.xlsx
0
 
Rob HensonFinance AnalystCommented:
@Rgonzo - not quite Snap!! Near enough for military work though!!

@GulfIT - both solutiuons have added a column to the data to separate the date from the "date & time" value. We have then formatted the resulting pivot differently.
0
Cloud Class® Course: Microsoft Office 2010

This course will introduce you to the interfaces and features of Microsoft Office 2010 Word, Excel, PowerPoint, Outlook, and Access. You will learn about the features that are shared between all products in the Office suite, as well as the new features that are product specific.

 
nathanielIT ConsultantCommented:
Use MIN instead of Count in Pivot

Here's how:

1. On Column F use the formula: =TEXT(A2,"mmm-dd")
2. label this column as MonthDay
3. On Pivot Table settings, drop the User and MonthDay to Row Labels box
4. Then Drop the Date into the Values box, setting it from Count to Min
5. On the Pivot display, set the cell format of Date (Min of Date) to Time format.

Hope this helps
0
 
Rgonzo1971Commented:
@Rob
Your answer didn't show yet and I wasn't sure what the author ultimately wanted
0
 
GulfITAuthor Commented:
Thanks that worked.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: CompTIA Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now