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!”
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