Question about Microsoft Excel for PC

1 Answer

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

Posted by 2net on

  • 1 more comment 
  • 2net Aug 09, 2008

    Here is what I as trying to do

  • 2net Aug 10, 2008

    you sent me a link for a simple tutorial for using Excel. If I needed it to be simple I would not have asked. The "SIGN" function isn't even it. Read it yourself. Do you understand the question posted? At least I'm honest enough to admit I don't know what to do. It is inappropriate because it's not what is needed.

  • 2net Aug 10, 2008

    It is irrelevant. And since you are not an excel please do us, the excel users, don't medle when you don't know. You are wasting my time.



1 Answer

Richard Finch

  • Level 3:

    An expert who has achieved level 3 by getting 1000 points


    An expert that got 10 achievements.


    An expert that got 5 achievements.


    An expert who has achieved Level 3.

  • Master
  • 397 Answers

You might be able to find what you want here:

Posted on Aug 10, 2008

  • Richard Finch Aug 10, 2008

    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

  • Richard Finch Aug 10, 2008

    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.



Add Your Answer

Uploading: 0%


Complete. Click "Add" to insert your video. Add



Related Questions:

1 Answer

Could I please have phone number for claiming attendance allowance as I don't have a copier and not very clever on this device

We are FIXYA dot com and I am guessing not who you think you are addressing. However, this might be it?

0345 605 6055
You can get a claim form by phoning 0345 605 6055 (text phone 0345 604 5312), or you can download a form from the government website (

Disability benefits: Attendance Allowance - Independent Age
phone number for claiming attendance allowance Google Search

Jul 24, 2018 | Lands Phones

1 Answer

Mrs. Jones lets her students wear fuzzy slippers to school if they earn 30 stickers. She gives them 4 stickers for every week that they have perfect attendance. Kelsie already has 8 stickers. Which i

Let x be the number of future weeks.

8 + 4x >= 30

Solve for x by subtracting 8 from each side and dividing by coefficient in front of variable. Plug answer into original equation to check that it works correctly.

Good luck,


Jan 28, 2014 | Casio FX-115ES Scientific Calculator

1 Answer

Java project (core and advanced)

As for the topic, I think what you could look into is and I.D. system with automated time and attendance computation. One that would also computer the number of hours worked, overtimes, lates and so on. To make your system extensive. You can actually create a standalone application for system logins and also online. Then you could also setup an online login for different users to check their attendance reports. Look into using different frameworks to make it easier for you. Try to look into Ibatis, Hibernate and so on.

May 29, 2009 | Microsoft Windows XP Professional

Not finding what you are looking for?

Open Questions:

See all Microsoft Excel for PC Questions

Microsoft Excel for PC Logo

157 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts


Level 3 Expert

13434 Answers

Lee Hodgson
Lee Hodgson

Level 3 Expert

4810 Answers


Level 3 Expert

1997 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides