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 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

  • 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

Which are the top reasons to use small business management software?

If you are a business owner of a small business you surely have heard of small business management software.You might likewise be questioning whether this kind of software application would be suitable for the needs of your business.
Small business management software is web based meaning that the only thing an employee needs to access it is a PC and an internet connection. This therefore facilitates working from home or even in another country.

Chamber management software is web based meaning that the only thing an employee needs to access it is a pc and an internet connectivity.This therefore facilitates working from house or even in another country.
Only one application is needed to create and store your documents,invoices,time sheets,projects,attendance,etc.So no more having too much load several applications each morning and switch between them to complete projects and tasks. Leads can be turned into sales in a much more streamlined way by using small business management software as all information is held in one place.
These are the main reasons to use small business management software not only revolutionize your business it can help to increase profits, decrease in efficiency and raise customer satisfaction so it will be very beneficial for small business.

Jun 15, 2016 | The Business & Productivity Software

3 Answers

What Happens If I Make A Late Payment On Business Loan?

Mary, You will be way further ahead contacting the the lender of the loan ahead of time a some times at there discretion late fees or penalties fees can be waived. Some allow 1 per year with in reason. So if you know you are going to be late notify them ahead of time.
"I hope this helped you out, if so let me know by pressing the helpful button. Check out some of my other posts if you need more tips and info."

May 04, 2016 | Business & Productivity Software

1 Answer

How program to compute the average for any number students ?

The easiest way is to add a field, name it attendance or something and assign a value of one. Then sum column a / sum column b for average.

Feb 18, 2015 | Microsoft Excel for PC

1 Answer

Number of days past the due date as a percentage?

That would depend on the terms of the payment. Two days late on a daily payment would be 200% while two days late on an annual payment would be about half a percent.

Jul 29, 2013 | Business & Productivity Software

1 Answer

My problam my laptop ms office student 60 days triel version los pls my help

You will have to purchase the full version, unless your school or employer offers it in a software package for free with attendance like my school.

Mar 05, 2011 | Microsoft Office Professional 2007 Full...

1 Answer

I want to make attendance sheet that entered in time and out time after complete the month, then give me report in total working hours.

You can find quite a few timesheets templates in Microsoft's site but most of them does not do the computation - I found one that does.called "Weekly Labor Expenditure Log" (see picture below). You can download it for free and adapt it for your purposes - let me know if you need help. I can forward it to you if you cannot find it




Mar 03, 2011 | Microsoft Office Excel 2007 Upgrade:...

1 Answer

Have a late invoice

You have to setup finace charges in preferences.

Dec 20, 2009 | Intuit QuickBooks Pro 2008: Windows

1 Answer

Attendance list/ headcount spreadsheet

Don't do this in Excel. Buy Visual Foxpro.
And make proper application.

Apr 11, 2009 | Microsoft Excel for PC

1 Answer

Formula for Date

Make that column fixed and give the variable date and value 26/Month of year/year

That is the logic Can you do that


Mar 21, 2008 | Microsoft Excel for PC

Not finding what you are looking for?
Microsoft Excel for PC Logo

145 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Business & Productivity Software Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18297 Answers

Sudeep Chatterjee
Sudeep Chatterjee

Level 3 Expert

3267 Answers

Are you a Microsoft Business and Productivity Software Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides