Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and the Yahoo Answers website is now in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.

Anonymous
Anonymous asked in Computers & InternetSoftware · 8 years ago

How do I change this formula to calculate time in Excel for an overnight shift?

I am using this formula: =HOUR(E27-D27)+ROUND(4*MINUTE(E27-D27)/60,0)/4 to calculate the time difference for a shift worked. E27 has the punch out time and D27 has the punch in time. The formula rounds the minute time to the nearest quarter for me. However it does not work for overnight hours. How can I edit this formula to calculate the right amount of hours for overnight hours? Please help!

2 Answers

Relevance
  • petti
    Lv 4
    5 years ago

    No i do no longer... yet in simple terms as others would not have a say in how I develop my little ones, I would not have a say in how others develop their little ones. i'm against indoctrination yet i can't see the thank you to combat it without removing the freedoms of others. I advise what if somebody advised you it replaced into incorrect to allow your babies play with Ninja turtles action figures via fact it advocates vigilantism? So whilst my very own opinion is that teachings interior the bible directed in direction of youthful babies that glorify the violence and genocide interior the bible employing action figures are certainly incorrect.. i can't overlook that individuals would think of the same approximately many different action figures and the ideals they represent. as quickly as you commence there it won't provide up at that, exceedingly quickly any violent action figures would be banned.. as an occasion i think of Bratz dolls instruct females to be self-based and shallow, yet is it my place to tell human beings they might't purchase them for his or her babies? No it is not. i does not choose somebody else telling me what my little ones can play with this is appropriate, so I won't do it to individuals.

  • FatGuy
    Lv 6
    8 years ago

    I would store time in 24hr format

    If punch out time is < punch in time, assume next day. add 24hrs to punch out time.

Still have questions? Get your answers by asking now.