Here are some problems that our users have asked and received explanations on
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
I have minute and second in one cell (e.g 3:23) in formula command it is showing (e.g 3:23:00 AM).
It is 3 minute and 23 seconds.
I need help to convert this into seconds in a separate column.
Solved by X. W. in 16 mins
Adding minutes and seconds in excel...it won't let me
Solved by Z. H. in 24 mins
I have data being recorded every 30 seconds displayed in one cell as "mm/dd/yyyy hh:mm:ss AM/PM". How do I filter the rows so I get only one data point every 6 hours instead of every 30 seconds?
Solved by K. F. in 27 mins
I want to be able to record timestamps in excel in the format h:mm:ss AM/PM. I am using the keyboard shortcut "ctrl+shift+:" because I need to be able to record it quickly. But the result is in hours and minutes with no seconds. And if I format the cell before or after to include seconds, it just shows 00 seconds. Please help me.