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

Posted on 2016-11-14
Last Modified: 2016-11-14

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.
Question by:GulfIT
LVL 32

Accepted Solution

Rob Henson earned 500 total points
ID: 41886010
See attached.
LVL 49

Expert Comment

ID: 41886011

Is that what you are looking for?

LVL 32

Expert Comment

by:Rob Henson
ID: 41886015
@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.
Problems using Powershell and Active Directory?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why


Expert Comment

ID: 41886016
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
LVL 49

Expert Comment

ID: 41886070
Your answer didn't show yet and I wasn't sure what the author ultimately wanted

Author Closing Comment

ID: 41886170
Thanks that worked.

Featured Post

Is Your AD Toolbox Looking More Like a Toybox?

Managing Active Directory can get complicated.  Often, the native tools for managing AD are just not up to the task.  The largest Active Directory installations in the world have relied on one tool to manage their day-to-day administration tasks: Hyena. Start your trial today.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
formula how to get the number incrementor? 3 23
how to add loop into this VBA 3 29
Assigning VBA code to a specific worksheet 3 25
Excel Formula 16 46
A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

823 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question