Hello all,
I hope someone can help me.
My data looks like this;
Column A = Person Name
Column B = Start DateTime (DD/MM/YYYY hh:mm:ss)
Column C = Finish DateTime (DD/MM/YYYY hh:mm:ss)
What I would like is a formula to calculate the MIN Start DateTime and MAX Finish DateTime based on a persons name set in E1 and a preset date value in DD/MM/YYYY format set in E2. If the results could be displayed in F1 Start and F2 Finish that would be great.
ie; What time did Andrew start working on 01/01/2013 and what time did he finish on the same day.
The persons name could be duplicated numerous times in a day, as and when they would start a project and finish a project.
Any help would be great as I'm having a bad day and my head hurts....
Thanking you in advance
Bookmarks