Home

calculating hours

%3CLINGO-SUB%20id%3D%22lingo-sub-639175%22%20slang%3D%22en-US%22%3Ecalculating%20hours%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-639175%22%20slang%3D%22en-US%22%3Ehow%20do%20i%20calculate%20hours%3CBR%20%2F%3E%3CBR%20%2F%3Eex1.%20if%2006%3A55%20is%20rounded%20as%2007%3A00%2C%20and%2015%3A05%20rounded%20is%2015%3A00%2C%20and%20the%20answer%20should%20be%20in%20the%20form%20of%208.0%20hours%3CBR%20%2F%3E%3CBR%20%2F%3Eex2.%20if%2013%3A25%20is%20rounded%20as%2013%3A30%20plus%2020%3A35%20rounded%20as%2020%3A30%20equals%20to%207.0%20hours%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-639175%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-642639%22%20slang%3D%22en-US%22%3ERe%3A%20calculating%20hours%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-642639%22%20slang%3D%22en-US%22%3EYou%20can%20use%20a%20formula%20like%3A%3CBR%20%2F%3E%3DMROUND(C2%2C%E2%80%9D0%3A30%E2%80%9D)-MROUND(B2%2C%E2%80%9D0%3A30%E2%80%9D)%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-642752%22%20slang%3D%22en-US%22%3ERe%3A%20calculating%20hours%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-642752%22%20slang%3D%22en-US%22%3Ethank%20you%20for%20replying%2C%20although%20not%20what%20im%20trying%20to%20solve%20maybe%20because%20i%20gave%20a%20different%20numbers%20to%20show%20my%20situation%2C%20anyways%20this%20is%20the%20exact%20hours%20im%20trying%20to%20resolve%3CBR%20%2F%3E%3CBR%20%2F%3Estarting%20time%20of%209%3A06%20and%20ended%2014%3A03%20generating%204%3A45%20but%20instead%20of%204%3A45%20i%20need%20to%20show%20that%20as%204.75hours%3CBR%20%2F%3E%3CBR%20%2F%3Ethanks%20again%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-642800%22%20slang%3D%22en-US%22%3ERe%3A%20calculating%20hours%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-642800%22%20slang%3D%22en-US%22%3EThe%20difference%20is%204%3A57%2C%20not%204%3A45.%20How%20did%20you%20arrive%20at%204%3A45%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-643226%22%20slang%3D%22en-US%22%3ERe%3A%20calculating%20hours%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-643226%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F280482%22%20target%3D%22_blank%22%3E%40Twifoo%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethis%20is%20how%20I%20wanted%2C%20i%20dont%20know%20how%20it%20is%20rounded%20but%20at%20my%20work%2C%206%3A55%20AM%20is%207%3A00%20AM%2C%20whereas%203%3A36%20PM%20is%203%3A45%20PM%2C%20and%20total%20is%208%20hours%20and%2045%20mins%2C%20and%20the%20hardest%20part%20is%20to%20show%20not%208%3A45%20but%208.75%3C%2FP%3E%3CP%3Ethank%20you%20very%20much.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-643425%22%20slang%3D%22en-US%22%3ERe%3A%20calculating%20hours%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-643425%22%20slang%3D%22en-US%22%3EI%20advise%20you%20to%20inquire%20about%20the%20algorithm%20of%20how%20work%20hours%20are%20calculated.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-646160%22%20slang%3D%22en-US%22%3ERe%3A%20calculating%20hours%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-646160%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F280482%22%20target%3D%22_blank%22%3E%40Twifoo%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethats%20how%20it%20is%20at%20work%2C%20punches%20after%205%20minutes%20after%20scheduled%20time%20is%20rounded%20up%2015%20minutes%20or%200.25%20hour%20late%2C%20and%20punches%205%20minutes%20before%20scheduled%20time%20rounded%20down%2015%20minutes%20or%200.25%20hour%20early%2C%20ex%3A%20%26nbsp%3B%20%26nbsp%3BIN%20-%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B15%3A06%3C%2FP%3E%3CP%3E%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20OUT%20-%20%26nbsp%3B%20%26nbsp%3B%2019%3A50%3C%2FP%3E%3CP%3E%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20TOTAL%20-%20%26nbsp%3B4.5%20HOURS%3C%2FP%3E%3C%2FLINGO-BODY%3E
dieseldycke
New Contributor
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
You can use a formula like:
=MROUND(C2,”0:30”)-MROUND(B2,”0:30”)
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
The difference is 4:57, not 4:45. How did you arrive at 4:45?

@Twifoo 

 

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.

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

@Twifoo 

 

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
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
PacketMon Components are not loading in WAC 1909
HotCakeX in Windows Admin Center on
2 Replies