Forum Discussion
Robert Hart
Nov 08, 2021Copper Contributor
Time Conversion to Decimal
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 hou...
- Nov 08, 2021
Robert Hart Multiply by 24. I.e. in C3 =B3*24 and copy it down.
Riny_van_Eekelen
Nov 08, 2021Platinum Contributor
Robert Hart Multiply by 24. I.e. in C3 =B3*24 and copy it down.
Robert Hart
Nov 14, 2021Copper Contributor
Thank you so much!!