Forum Discussion
3131fisherman
May 23, 2022Copper Contributor
Help converting hours, minutes and seconds to decimals
Hey! Any help with this will be much appreciated!
I want to convert 8091:36:22 (Hours:Minutes:Seconds) to just hours in one number (with decimals). How can I easily do this in Excel?
My skills are just too bad..
3 Replies
- SergeiBaklanDiamond Contributor
Just multiply on 24 (if time is in A1, =A1*24) and apply General format
- 3131fishermanCopper ContributorThanks! What if I want it to be just minutes instead of hours? Multiply by 1440?
- BeyK40Brass ContributorYes.