Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be 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.
Trending News
How to calculate this time to nearest quarter hour?
I need to calculate to the nearest quarter hour; Worked 8 am - noon, 7:15 AM - 5:45 PM, 7:15 AM-5:45 PM, 8:30 am-4:30 pm. 5:30 pm -7:15 pm. I am getting 34.75 hours worked, is this correct or am I miscalculating my time worked?
6 Answers
- SqdancefanLv 74 years ago
For the numbers given, your sum is correct.
If the time periods you list include a lunch break, make sure you're getting a paid lunch break before you count it as time worked. Claiming time that wasn't worked is generally grounds for termination.
- ?Lv 74 years ago
Use a 24-hour clock
12:00 - 8:00 = 4:00
8am to noon is 4 hours
17:45 - 7:15 = 10:30
7:15am to 5:45pm is 10.5 hours
16:30 - 8:30 = 8:00
8:30am to 4:30pm is 8 hours
19:15 - 17:30 = 1:45
5:30pm to 7:15pm is 1 hour and 45 minutes = 1.75 hours
4 + 2·10.5 + 8 + 1.75 = 34.75 hours
- How do you think about the answers? You can sign in to vote the answer.
- ?Lv 74 years ago
One way to do it is to convert all times to minutes.
You do this by
AM times - multiplying 60 times the hour and adding that number to the minutes
PM times - multiplying 60 times (12 + the hour) and adding that number to the minutes
So, for example:
7:15 AM - 5:45 PM
start = 7 * 60 + 15 = 435
end = (5 + 12) * 60 + 45 = 1065
time worked
1065 - 435 = 630 minutes
now divide by 60 to get the hours, remainder equals minutes
hours = 10, minutes = 30
SO:
convert all times to minutes
subtract starting times from ending times to get time worked each shift
add the results of all the time worked
convert that to hours and minutes dividing by 60
