How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask Ray Atkinson Your Own Question

Ray Atkinson
Ray Atkinson, Graduate Student
Category: Homework
Satisfied Customers: 1793
Experience:  Degrees in Math, Education and Accounting, years and years of tutoring.
29937297
Type Your Homework Question Here...
Ray Atkinson is online now
A new question is answered every 9 seconds

calculating hours worked on an current excel

Customer Question

I need help with calculating hours worked on an current excel spreadsheet in order to calculate overnight shift..ex 22:00 till 05:00 should be 7 hours


 


 I have spread sheet available to review

Submitted: 1 year ago.
Category: Homework
Expert:  Ray Atkinson replied 1 year ago.

Ray Atkinson :

I'm rather good with Excel. Do you have a way to upload the file so I can look at it?

Customer:

yes

Ray Atkinson :

Depending on your browser, you should have a paperclip icon above where you type that says "insert/edit image"

Ray Atkinson :

oh, good. Can I have the link?

Ray Atkinson :

Also, when do you need this finished? If you need it tonight, I can stay up. If not, I can get it done in the morning. It is 0311 local

Customer:

I need it before 6am

Ray Atkinson :

ok, I am getting the file. 6am what time zone?

Ray Atkinson :

eastern US?

Customer:

central

Ray Atkinson :

All right. 3+ hours

Ray Atkinson :

Hmmm. file conversion failed. Let me try again.

Ray Atkinson :

It is possible for you to save it as a regular .xls file rather than .xlsx ?

Customer:

let me check

Ray Atkinson :

Excel 2003 instead of Excel 2007

Ray Atkinson :

My aVersion of excel will not open it.

Ray Atkinson :

awesome.

Ray Atkinson :

Oh, that did not work. It came through garbled.

Ray Atkinson :

The first line is








PK!Çz—x [Content_Types].xml ¢( Ì&r dquo;ßJÃ0Æïß¡äVÚlDdÝ.¦^êÀù19]ËÒ$äds{{O³?ȨÂÞ4´9çû~Išo8^×:YÇÊšœõ³KÀH«*3ÏÙûì9½g
Ray Atkinson :

How about you describe what you are needing?

Ray Atkinson :

Are all the "in" times later than the "out" times?

Customer:

think I got it fixed

Ray Atkinson :

ok, let me get

Ray Atkinson :

MUCH better

Ray Atkinson :

Ok, dumb questions time. Are hours in as 24 hour clocks, as in not 4:00 PM but 1600?

Ray Atkinson :

May I add additional columns if I hide them?

Ray Atkinson :

(I use hidden columns to do intermediate calculations)

Customer:

did it work

Ray Atkinson :

the file looks great.

Customer:

thats fine...whatever it takes

Customer:

time is in military format

Ray Atkinson :

Excellent. That makes my job easier.

Customer:

what happens is that Im getting a -15 hours when it crosses over midnight cause it doesnt calculate it correctly. I attempted to add the dates into the calculations but of course I failed at it

Customer:

I just want it to read the hours correctly. so If I say 22:00 to 02:00 it sould say 4hrs

Ray Atkinson :

I have the calculations done for going over midnight. Now I am working on the overtime hours. anything over 8 in one period, right?

Customer:

yes sir

Ray Atkinson :

Ok,. give me a couple minutes.

Customer:

can we just leave the calculation for ot out...

Customer:

nvm...go ahead

Customer:

yea..lets not calculate OT

Customer:

becasue it could change, I rather enter it manaully

Ray Atkinson :

Well, I streamlined the calculation for overtime. See if you like it. I did set it up for being over 8 hours a day

Ray Atkinson :

If you do not, just copy and paste from the old file.

Ray Atkinson :

give me a sec to save it.

Customer:

ok

Customer:

I think the current policy is that anything over 40 is OT...so not over 8 in a day yet, got get to 40 first

Ray Atkinson :

oh! do you want me to try to implement that?

Ray Atkinson :

I don't think that would be hard.

Customer:

sure

Ray Atkinson :

Actually that is much easier.

Customer:

sweet

Ray Atkinson :

Give this a look:

Ray Atkinson :

Whoops!

Ray Atkinson :

40 hours a week, not per 2 weeks,.

Ray Atkinson :

bug fix

Customer:

looks good

Ray Atkinson :

Not good enough.

Ray Atkinson :

Now, it checks for 40+ hours per week, not for a 2 week pay period.

Customer:

awesome....

Ray Atkinson :

I forgot that payslip was for 2 weeks

Customer:

no problem...

Ray Atkinson :

If you look at row 18, you see the check for overtime for week 1

Ray Atkinson :

26 is for week 2

Customer:

got it

Customer:

can you upload the one you corrected?

Ray Atkinson :

If the time is like from 22:00 to 02:00, it does the 2-22 and get -20, but then adds 24 to get the proper answer.

Ray Atkinson :

I didn't?

Customer:

my bad...I got it...its late

Ray Atkinson :

You can unhide columns E and H to look at the formulas.

Ray Atkinson :

Not a problem. I enjoy playing with Excel. There is an old joke that fur trappers used sheets over their shoulders to cover their tracks and people use spreadhsheets to do the same thing now.

Customer:

funny

Ray Atkinson :

Sorry. Had box checked.

Ray Atkinson :

You can try to rate now, if you please?

Ray Atkinson, Graduate Student
Category: Homework
Satisfied Customers: 1793
Experience: Degrees in Math, Education and Accounting, years and years of tutoring.
Ray Atkinson and other Homework Specialists are ready to help you

JustAnswer in the News:

 
 
 
Ask-a-doc Web sites: If you've got a quick question, you can try to get an answer from sites that say they have various specialists on hand to give quick answers... Justanswer.com.
JustAnswer.com...has seen a spike since October in legal questions from readers about layoffs, unemployment and severance.
Web sites like justanswer.com/legal
...leave nothing to chance.
Traffic on JustAnswer rose 14 percent...and had nearly 400,000 page views in 30 days...inquiries related to stress, high blood pressure, drinking and heart pain jumped 33 percent.
Tory Johnson, GMA Workplace Contributor, discusses work-from-home jobs, such as JustAnswer in which verified Experts answer people’s questions.
I will tell you that...the things you have to go through to be an Expert are quite rigorous.
 
 
 

What Customers are Saying:

 
 
 
  • Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help. Mary C. Freshfield, Liverpool, UK
< Last | Next >
  • Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help. Mary C. Freshfield, Liverpool, UK
  • This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!! Alex Los Angeles, CA
  • Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult. GP Hesperia, CA
  • I couldn't be more satisfied! This is the site I will always come to when I need a second opinion. Justin Kernersville, NC
  • Just let me say that this encounter has been entirely professional and most helpful. I liked that I could ask additional questions and get answered in a very short turn around. Esther Woodstock, NY
  • Thank you so much for taking your time and knowledge to support my concerns. Not only did you answer my questions, you even took it a step further with replying with more pertinent information I needed to know. Robin Elkton, Maryland
  • He answered my question promptly and gave me accurate, detailed information. If all of your experts are half as good, you have a great thing going here. Diane Dallas, TX
 
 
 

Meet The Experts:

 
 
 
  • Manal Elkhoshkhany

    Tutor

    Satisfied Customers:

    4522
    More than 5000 online tutoring sessions.
< Last | Next >
  • http://ww2.justanswer.com/uploads/BU/BusinessTutor/2012-2-2_115741_Kouki2.64x64.jpg Manal Elkhoshkhany's Avatar

    Manal Elkhoshkhany

    Tutor

    Satisfied Customers:

    4522
    More than 5000 online tutoring sessions.
  • http://ww2.justanswer.com/uploads/ComputersGuru/2010-02-13_051118_Photo41.JPG LogicPro's Avatar

    LogicPro

    Engineer

    Satisfied Customers:

    3458
    Expert in Java C++ C C# VB Javascript Design SQL HTML
  • http://ww2.justanswer.com/uploads/LI/lindaus/2012-6-10_04811_IMG20120609164157.64x64.jpg Linda_us's Avatar

    Linda_us

    Finance, Accounts & Homework Tutor

    Satisfied Customers:

    3124
    Post Graduate Diploma in Management (MBA)
  • http://ww2.justanswer.com/uploads/chooser77/2009-08-18_162025_Chris.jpg Chris M.'s Avatar

    Chris M.

    M.S.W. Social Work

    Satisfied Customers:

    2385
    Master's Degree, strong math and writing skills, experience in one-on-one tutoring (college English)
  • http://ww2.justanswer.com/uploads/JawaadAhmed/2009-6-27_12137_SIs_SHadi.jpg F. Naz's Avatar

    F. Naz

    Chartered Accountant

    Satisfied Customers:

    1988
    Experience with chartered accountancy
  • http://ww2.justanswer.com/uploads/JK/jkcpa/2011-1-16_182614_jkcpa.64x64.jpg Bizhelp's Avatar

    Bizhelp

    CPA

    Satisfied Customers:

    1876
    Bachelors Degree and CPA with Accounting work experience
  • http://ww2.justanswer.com/uploads/avremote/photoa.jpg Seanna's Avatar

    Seanna

    Tutor

    Satisfied Customers:

    1781
    3,000+ satisfied customers, all topics, A+ work
 
 
 

Related Homework Questions