Forum Discussion
johnae6ws
Sep 11, 2020Copper Contributor
How do I convert HH:MM:SS to a numeric value
Looking for a way to use a formula function to change time to a number. IE a time of action is 6 hours and 30 minutes. I would like to convert this to 6.5 for the purpose of calculations. J...
Abiola1
Sep 11, 2020MVP
Hello,
I believe the post in the link below answers you question.
https://www.ablebits.com/office-addins-blog/2015/07/01/excel-convert-time-decimal/
Kindly go through it..
Regards
I believe the post in the link below answers you question.
https://www.ablebits.com/office-addins-blog/2015/07/01/excel-convert-time-decimal/
Kindly go through it..
Regards