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!
Pingback: Converting HH:MM:SS to hours in decimal
Pingback: HRS to whole number