Forum Discussion
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
Just multiply on 24 (if time is in A1, =A1*24) and apply General format
- Thanks! What if I want it to be just minutes instead of hours? Multiply by 1440?
- Yes.
