Do you need TIME?

To convert [hour:minute] into number of hours quickly.

If you are working in HR field, you may need to calculate wages for part-time staff whose salary is paid on hourly basis.  So you need to convert 8:45 (8 hrs 45 mins) into 8.75 hours, how to do it in Excel?

The solution is as simple as Multiplying TIME (time format) by 24, i.e. [TIME] x 24 = Number of hours (remember to format the result as number with decimals)


It makes total sense if you know how Excel stores time as value.

In Excel, 00:00 is stored as 0 while 12:00 as 0.5 and 24:00 as 1.

In this way 24 hours are evenly divided into 0 to 1.  Does it make sense to convert it into number by multiplying 24?

If you don’t understand this, you may refer to your high school maths… 😛


Sometimes, less is more! 


About MF

An Excel nerd who just transition into a role related to data analytics at current company......😊 Recently in love with Power Query and Power BI.😍 Keep learning new Excel and Power BI stuffs and be amazed by all the new discoveries.
This entry was posted in Formula and tagged . Bookmark the permalink.

2 Responses to Do you need TIME?

  1. Pingback: Converting HH:MM:SS to hours in decimal

  2. Pingback: HRS to whole number

Comments, suggestions, corrections are welcome.

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.