Get instant live expert help on I need help with mins to seconds

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

Hello, I have a column (Named raw data) that contains a time value. The values come in the format of "_ hrs _ mins _ secs" An example is "9 hrs 20 mins 0 secs". However if there is no hour in the raw data, it fills in with “_ mins _ secs”. An example is 40 mins 57 secs. Then I have columns for Hours, Minutes, and Seconds that need to be filled out from the raw data mentioned above.
Solved by Z. Y. in 20 mins
I have this in excel that show the hours and mins, The format is in [h]:mm but I need sum up the total time. 92 hours 26 mins 92 hours 26 mins 92 hours 26 mins every time I try to add them gives me an error.
Solved by Z. L. in 30 mins
Hi, I need a formula to calculate minutes into hours and minutes. i.e, 0.10 0.20 0.50 = 0.80 mins - need formula to convert to 1.20 - 1hr 20 mins thank you
Solved by M. C. in 14 mins
I need to average the 6 times which are expressed in minutes, seconds, hundredth of seconds - example 7:09.96, 6:52.62, 7:03.85, 7:00.58, 6:51.56, 6:43.97
Solved by V. U. in 27 mins
Need to calculate date in excel - should not take more than 30 mins or so to complete
Solved by K. B. in 16 mins