LinkBack URL
About LinkBacks
I need to convert 1h15m20s to decimal time. I expect this to be 1.256 but don't know how to go about it.
I need to convert 1h15m20s to decimal time. I expect this to be 1.256 but don't know how to go about it.
Assuming that text in A1:
Try:
Please Login or Register to view this content.
Quang PT
Thank you bebo021999, what if in the list I have some with only minutes and seconds, say 42m30s?
Try again:
Please Login or Register to view this content.
Once again many thanks.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks