• 460K Members
• 15.6K Online
• 557K Conversations

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

# Re: calculating hours

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

# 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

# Re: calculating hours

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

# 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.

# Re: calculating hours

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

# 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

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies