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!