How to Convert time from xx minutes to xx Seconds into HH:MM:SS
Requirement:
Basically the user has a list of 'times' in the format '18 Minutes 12 Seconds' is there any easy way to convert these into the format '00:18:12'?
Solution:
If in cell A1 you have your Text : 18 Minutes 12 Seconds
in cell A2 you can have following formula :
Code:
=(VALUE(LEFT(A1,FIND("Minutes",A1)-2))/1440)+(VALUE(MID(A1,FIND("Seconds",A1)-3,LEN(A1)-FIND("Seconds",A1)-4))/86400)
Then, you can format cell A2 as needed... e.g. [hh]:mm:ss
Obtained from the OzGrid Help Forum.
Solution provided by Carim.
See also: Index to Excel VBA Code and Index to Excel Freebies and Lesson 1 - Excel Fundamentals and Index to how to… providing a range of solutions and Index to new resources and reference sheets
See also:
| How to obtain True/False statement if times are within x minutes of each other |
| How to calculate hours based on individual daily rates |
| How to calculate overtime on Timesheet after 10 hours per day AND/OR 44 hours per week |
Click here to visit our Free 24/7 Excel/VBA Help Forum where there are thousands of posts you can get information from, or you can join the Forum and post your own questions.
Gallery
