Highlighted
New Contributor

# calculating hours

how do i calculate hours

ex1. if 06:55 is rounded as 07:00, and 15:05 rounded is 15:00, and the answer should be in the form of 8.0 hours

ex2. if 13:25 is rounded as 13:30 plus 20:35 rounded as 20:30 equals to 7.0 hours
6 Replies
Highlighted

# Re: calculating hours

You can use a formula like:
=MROUND(C2,”0:30”)-MROUND(B2,”0:30”)
Highlighted

# Re: calculating hours

thank you for replying, although not what im trying to solve maybe because i gave a different numbers to show my situation, anyways this is the exact hours im trying to resolve

starting time of 9:06 and ended 14:03 generating 4:45 but instead of 4:45 i need to show that as 4.75hours

thanks again
Highlighted

# Re: calculating hours

The difference is 4:57, not 4:45. How did you arrive at 4:45?
Highlighted

# Re: calculating hours

this is how I wanted, i dont know how it is rounded but at my work, 6:55 AM is 7:00 AM, whereas 3:36 PM is 3:45 PM, and total is 8 hours and 45 mins, and the hardest part is to show not 8:45 but 8.75

thank you very much.

Highlighted

# Re: calculating hours

I advise you to inquire about the algorithm of how work hours are calculated.
Highlighted

# Re: calculating hours

thats how it is at work, punches after 5 minutes after scheduled time is rounded up 15 minutes or 0.25 hour late, and punches 5 minutes before scheduled time rounded down 15 minutes or 0.25 hour early, ex:    IN -        15:06

OUT -     19:50

TOTAL -  4.5 HOURS