So I have a list of employees with their start date/ time and their stop date/ time. I'm trying to identify if they were were working during a particular hour of day. Most of the IF(AND) formulas work as long as they clock in and out on the same day. On the attachment it shows some sample data and what I would expect it to populate with. My end goal is to be able to show which hours of the day an employee was working. ANY help would be greatly appreciated.
I'm not a date/time formula expert...but
Using your posted workbook, this regular formula, copied across and down, returns the values you're looking for
Is that something you can work with?
Please Login or Register to view this content.
Ron,
This is fantastic! First I want to thank you for the quick response! I applied the formulas to my master template and it works great! I'm embarrassed to tell you how much time I spent attempting this yesterday on my own.
Again, many many thanks for your assistance!
Best regards,
Mark
Glad you got something you can use!
If that resolves your issue, please take a moment to mark this thread as SOLVED (from the Thread Tools menu)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks