Nov 08 2021 02:21 AM
How can I set up a formula to convert times to decimal?
In the attached sample, I have times in Column B and want to convert those times to decimal for payroll purposes.
Example: B3 is 10 hours 30 minutes. (I know the result in decimal should be 10.50 but I don't know how to create the conversion formula)
Nov 08 2021 02:23 AM - edited Nov 08 2021 02:25 AM
Solution@Robert Hart Multiply by 24. I.e. in C3 =B3*24 and copy it down.
Nov 08 2021 02:23 AM - edited Nov 08 2021 02:25 AM
Solution@Robert Hart Multiply by 24. I.e. in C3 =B3*24 and copy it down.