PDA

View Full Version : Conditional Min and max in a hour format



roxanaoana
02-13-2014, 04:47 AM
HI,

I need to calculate the min hour and the max hour for a report.
As you can see in the attached excel, in sheet A I have exported the daily activity data base. When the users have logged on and off.
The issue is that during the day they can be logged off due to various reasons.
I need to reproduce the fist log-in in sheet B column C for each user and each day of the mount. Also I will need to reproduce the last log-off in sheet B column D.

Due to the fact that we pass midnight with some shifts, on the column S (date) in sheet A we can find the real date of the shift not the date in witch we are after midnight.

Can you please have a look a help me in this matter?

Thank you,
Oana S