Attendance I'm creating an attendance tracker. I am having trouble when counting the number of minutes late and undertime. For LATE, it becomes a negative value when the employee comes in earlier than the scheduled time. Same as for UNDERTIME, it also becomes a negative value when they go home later than usual. When I get the total number of minutes late and undertime, it is not accurate because of the negative value. Example, Monday, the employee came in 30 minutes earlier then the next day came in 30 minutes late, then it's 0 total minutes lates, just like for undetime. Is there a formula that can be used for this. I'll appreciate your suggestions. Thanks a lot. ScheduleInOutAbsentLateUndertime 10:00 PM7:00 AM9:30 PM7:15 AM -0:30-0:15 10:00 PM7:00 AM10:30 PM6:45 AM0:000:00

Well, what was inappropriate in my answer. Inappropriate is used for answers that are abusive or out of context. I think I gave you a solution. Please remove the rating. Thanks Well, what was inappropriate in my answer. Inappropriate is used for answers that are abusive or out of context. I think I gave you a solution. Please remove the rating. Thanks

Inapropriate would suggest that I had posted some thing completely irrelevant.

I am not an Excel user I merely posted a link to a page that I thought might be able help you.

A simple thanks for trying would have been more appropriate, it is obvious that you are frustrated by this problem. I have a few friends who are regular Excel users, I have never spoken to them about Excel but should I get the chance within the next few days I will ask them and should they have any suggestions of how to help you I will post them back here for you. Inapropriate would suggest that I had posted some thing completely irrelevant.
I am not an Excel user I merely posted a link to a page that I thought might be able help you.
A simple thanks for trying would have been more appropriate, it is obvious that you are frustrated by this problem. I have a few friends who are regular Excel users, I have never spoken to them about Excel but should I get the chance within the next few days I will ask them and should they have any suggestions of how to help you I will post them back here for you.