title: How to display 1 hour 46 minutes in MS Excel cell where both the number count of hours and minutes comes from calculation?
body: <p>Suppose I sleep for 7 hours and 36 minutes. I have a sleeping threshold of 5 hours and 54 minutes. If I sleep more than threshold time, I get the time difference and If i sleep less than or equal to my sleeping threshold, i get the output as 'You slept Good". To do so, I scaled  zero to 60 minutes of actual time to 0 to 1 on a decimal scale, this way 7 hours 36 minutes comes as 7.6 and 5 hours 54 minutes comes as 5.9. </p>
  
  <p>Now, I take their difference which comes out to be 1.7 i.e. I slept extra for 1 hour and 0.7 minutes on 0to1 scale (which equals 1 hour 42 minutes on actual time scale). </p>
  
  <p>So, I used TRUNC function to display 1 h (i.e ! hour);  however I can't get my mind working as to how I can display 42 minutes in the same cell.</p>
  
  <p>i.e. my output should be 1h 42 min</p>
  
  <p><img src="https://i.stack.imgur.com/ZMbJh.png" alt="What I have done so far"></p>