Forum Discussion
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 ...
You can use a formula like:
=MROUND(C2,”0:30”)-MROUND(B2,”0:30”)
=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?
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.
