Wednesday, July 24, 2019

Excel Time Formula! Show 30 min as 0.50

Hello,

Recently, I wanted to convert time in numbers in a way, so that

  • 30 mins will be shown as 0.50 
  • 1 hour as1.00
  • And 1.45 as 1.75 
The requirement is to record my time spent and find out how much it is in numbers. After reviewing the problem for some time and searching on the net, I found if a number is in proper time format and if multiplied by 24 then we can get a number equivalent as I want it to be. But need to make sure the resulting cell is in number format. 

Like 1:15 * 24  = 1.25 

Following is a screenshot of my actual worksheet for everyone's reference.
















Thanx
Anshumaan Bakshi

No comments:

Post a Comment