1. S

    Formatting more than a months worth of seconds

    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...
  2. yashsrawat

    Complex sum of seconds

    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...
  3. K

    Decimal Seconds are being rounded by Excel

    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...
  4. L

    Transforming seconds to milliseconds

    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!
  5. J

    Extracting the number of seconds from a variable text string

    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...
  6. R

    EXCEL formula help

    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...
  7. U

    Convert 215 to 2:15

    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...
  8. F

    Using Hours, Minutes and Seconds in excel

    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...
  9. D

    Convert cummlative hh:mm:ss to minutes

    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...
  10. N

    Data Aquisition Time Stamp Issue

    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...

Some videos you may like

This Week's Hot Topics