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

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

    Master:

    An expert who has achieved Level 3.

  • Master
  • 397 Answers

You might be able to find what you want here:
http://www.usd.edu/trio/tut/excel/

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.

×

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

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,

Paul

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

1 Answer

Need a employee attendance software. i download a software its name is {Aquarius Soft Bepunctual}i need its keygen.pls anyone send me its key. Please...................


Its very difficult to choose reliable and user friendly software. You must consult with some one who got an experience with good user friendly software. try this
time and attendance tracking software

Apr 01, 2011 | Computers & Internet

1 Answer

The trans is shifting late.what could it be?


Sometimes automatics have trouble shifting when going up hills. If problem continues, you may want to get it checked out.

Jul 15, 2009 | 1995 Geo Tracker

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

2 Answers

C code for student attendance record


check this website, you will get all your answers there easily:
http://www.codeproject.com/
enjoy it!
Good luck

Jan 30, 2009 | Computers & Internet

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

146 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2644 Answers

Piyal Perera
Piyal Perera

Level 3 Expert

528 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18385 Answers

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

Answer questions

Manuals & User Guides

Loading...