• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 78
  • 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
Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

 
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

Featured Post

[Webinar] Kill tickets & tabs using PowerShell

Are you tired of cycling through the same browser tabs everyday to close the same repetitive tickets? In this webinar JumpCloud will show how you can leverage RESTful APIs to build your own PowerShell modules to kill tickets & tabs using the PowerShell command Invoke-RestMethod.

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