seconds

Hi, I want to round different time entries but I'm having problems with the seconds. If a time is less than 1 min, I want to round up to 1 min. But if the time is more than one min, I want to round up or down depending on the seconds (if <29sec then round down to lower min, if more than 30...

I have an excel spreadsheet with over 22,000 rows. Each row describes where a deer with a GPS collar was standing at a given time. I need to convert the time data, which is in Zulu, to time data that I can use arithmetically. I'm not sure what this unit is called, but seconds since Jan 1st 1900...

First, let me clarify that I am NOT trying to "convert" seconds to a "# of days, #of hrs, # of mins" ... I am trying to take a cell that has a number of seconds already in it, but I would like it "displayed (formatted) to show "# of days, #of hrs, # of mins". I'm struggling with finding a...

Hi I need to help to sum below values in 00:00:00 format, but it not working. If we add A+B+C=D, so it will give value in D col with 00:00:00 format can some one help me, A B c D 00:01:21 00:00:00 00:04:43 00:06:04 00:00:24 00:00:00 00:07:01 00:00:25...

I am using Excel 2013 to enter times in minutes and seconds to one decimal place. The cells have been formatted using the custom format mm:ss.0 When I enter 1:51.9, the value is displayed correctly in the cell i.e. 01:51.9 but if I edit the cell, 00:01:52 is shown in the formula bar and if I...

Hi there! I've got a data set with seconds (example: A1=1.2) and then I transformed it to time using =TIME(0,0,A1) and the format [h]:mm:ss.000 but it's showing 00:00:01.000 instead of 00:00:01.200. I don't know how to get the milliseconds!!! Can anyone there help me? Thanks!

I have a column of cells, each with a with text string that has three possible formats where I want to extract the total number of seconds. The three formats are: nnn hrs nn min nn sec (example: 1 hrs 42 min 58 sec) or nn min nn sec (example: 55 min 1 sec) or nn sec (example: 10 sec) The...

I have an Excel sheet where one column contains a time in the following format: 0000:00:32. I am trying to come up with a formula that will delet all of the zeros so that time will read as 32. I've tried everything and haven't had any luck yet. It's not as simple as just reformatting the...

When I export data from Google Analytics into Excel , the minutes and seconds are converted into a number, .e.g 2:15 > 215. How do I convert the number back to minutes and seconds or simply insert a colon? I manually changed 215 to 135 seconds, divided by 60 and formatted the cell but that seems...

Hi, I've got some lists of times in hours minutes and seconds for programme transcripts starting at a random number, for example one of my lists starts at 22 minutes and 30 seconds and then will have different time codes randomly for between 25 and 45 minutes. I need to minus the first value so...

I have a report that lists the amount of time people are logged out of a call center for various reasons. The time is cummulative for the day. I would like to add up the cummulative times for each reason and person for a month but the format is hh:mm:ss. I need to convert this to minutes...

Hello All, I have a large array of data that I am trying to work with. It is data from a data aquisition system. Each entry is marked with a date/time stamp. Due to elements beyond my control there are gaps in the data. For example it may jump from: Nov 28, 2008 06:15:00 to Nov 31, 2008...