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 20:30 equals to 7.0 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?
