Comments on: How to convert time to decimal number, hours, minutes or seconds in Excel

The tutorial demonstrates different ways to convert time to decimal in Excel. You will find a variety of formulas to change time to hours, minutes or seconds as well as convert text to time and vice versa. Continue reading →

Comments page 3. Total comments: 275

  1. I need to get the year, month, and day as separate integer values from a date such as 7/13/2014.

    How do I do that?

  2. August 1, 2020 3:52:15 PM AST
    how to change this one as date format , tried a lot, can you please guide me.

  3. 2 days 19 hours 40 minutes

    Its convert to 67.40 Dec... Can u plz send the excel formula

    1. Hello!
      What does 67.4 mean? What are these units of measurement?
      2 * 24 + 19 + 40/100? This number doesn't make sense.

  4. i have 261 minute. needs to be convert as HH:MM

    1. Hello!
      The formula below will do the trick for you:

      =CONVERT(D1,"mn","hr")/24

      Set the cell time format hh:mm

  5. Hello;
    Can you please help convert decimal 37.5 to hours and minutes.
    When converting a number under 24 hours the formula number/24 works but if totalling hours over a week, the formula does not work if the total goes over 1 day or 24 hours.
    Thank you

    1. Hello!
      To be able to show more than 24 hours in a cell, please use this time format: "37:30:55". You can find it in the list of Excel time formats.

    2. I am looking for the excel formula please :0)

  6. Hi,
    How to convert 9,30 in decimal 9,50 or 8,45 in 8,75.
    The times I receive in Excel are the effective times marked with a comma (none :)
    tnx

    1. Hello!
      The rounding of numbers in your examples occurs according to different rules. Therefore, I can not offer you a general formula for your two tasks. I recommend paying attention to the MROUND function. For your first example, the formula is suitable

      =MROUND(A1,0.5)

  7. I would like to convert time to a numerical number to add up total hours.
    Example:
    6:00AM-2:00PM=8 hours

    1. Hello Erica!
      Specify what you want to calculate. Your formula counts the time from 2 PM to 6 AM. And this is not 8, but 16 hours. If you want to calculate the time from 6 AM to 2 PM, then the formula is necessary
      = 2: 00 PM-6: 00AM
      To convert a result from time to number, use the formula
      = (2:00 PM-6:00AM) * 24
      And set the number format in this cell

  8. How do you convert 06:55 into 0655 in Excel. I want to to eliminate the colon.
    Thank you.

  9. I've downloaded a csv file that has a time on it but when I convert to Excel and use a formula on it it shows as the decimal equivalent of the number and not the time ,I cannot get to change to a time format that equals the original downloaded number/time

    1. Hello Geoff!
      Please try the formual below to convert time from a decimal number to "hh:mm:ss":
      =TIME(D1, MOD(D1, 1)*60, 0)

      That should do the trick.

      1. thank you but the issue I have would be say i wanted to concatenate 2 cells ..... one with contents CPark and the other 10:46 AM the concatenate function results CPark0.4486111111111111 rather than CPark10:46
        your suggestions effect upon the original 10:46 AM cell returns 12:26AM
        thank you for your help so far though

        1. Hello Geoff,

          Thank you for the clarification. In this case, formual below will convert your data from time to text:
          =CONCATENATE(A1, TEXT(B1, "hh:mm AM/PM"))

          That should do the trick.

          1. working now thank you Alexander !!!!

            1. so when I use a look up to cross reference 2 sheets in the same workbook even though I have the concatenate correct it doesn't pick up the cell I need ...can anyone have a look at the file if I send it to them to see where Im going wrong please ? I'm sure its due to the time format mentioned above that even though they look the same in the cell ref they are not .....

          2. sorry that is not the answer thanks Alexander although its probably on the right track
            I cannot find the solution anywhere on the internet

  10. Hello,
    In my excel spreadsheet I have column totally the number of hours in total (ex: from (9 am to to 10:30 am = 1.3) I would like to convert the 1.3 to 1.5. How add this function in my existing formula: =IF(k3≥J3,K3-J3,1-K3+J3)*L3..... L3 being the hours in total.
    Thank you!

    1. Hello Danielle!
      If I understand your task correctly, you need to convert time from HH:MM:SS format to decimals. If so, you just need to multiply it by 24 (for example, =А3*24) and set the General format for this cell.

  11. Has anyone actually found a resolution conversion for "D HRS:MIN:SEC" to "HRS"?
    eg. 1 22:12:00

  12. how to convert in date & Time format below value
    20001124204143.0Z

    1. I will try with Mod formula but 2020 value showing wrong this will shows in filter as 2020 Jan to Dec but still running feb month and when we check in Ctrl+Shift+3 format in 2020 date then showing another date.

  13. Please support how to convert time into hours duration i.e. OUT Time 10:23:28 AM and IN Time 7:27:31 PM need to calculate the duration in Excel for bulk data.

    Thanks.

    1. Hello Shahid,
      If you need the time difference in hh:mm:ss format, here is the formula for you:
      =IF(A2<A1, A2+1, A2)-A1

      Supposing the IN time is in A1 and OUT - in A2. If however, you need it to be a just number, the following formula will do the job:
      =HOUR(IF(A2<A1, A2+1, A2)-A1)+MINUTE(IF(A2<A1, A2+1, A2)-A1)/60

  14. How to format hours by using IF...
    Let's say I want from 06:00am to 22:00pm be "morning" and 22:00pm to 06:00am be "night".
    Thank you.

    1. Creating an Excel spreadsheet to use as a time card to keep track of the hours worked, I have used the formula =IF(end>start, end-start, 1-start+end) to reflect there are times I'll elapse (i.e. - go beyond midnight) to calculate the total number of hours. Now I need to convert that time into an hour and decimal minutes format to be able to calculate regular pay and overtime pay. How do I do that?

  15. Hello,
    Is there a format type or other way to quickly type hours to cell?
    For example I want to add time 21:00 by typing only "21".
    I have tried multiple different formats and if I type "21" it turns out 0:00.
    Any idea about the format I should use?

    1. Ville,
      Format cell as Custom, adding in "Type:" 00":"00
      So for eg. 7:15 you type 715

      Hope this helps,
      Davor

  16. HELLO DEAR,
    CAN I CONVERT NUMBER FORMET FOR EXAMPLE 1.75 IN TO TIME FORMET FOR EXAMPLE 1.45 HOURS IN MS EXCEL.
    9015223435

    1. I UNDERSTAND THAT YOU WOULD LIKE TO CONVERT NUMBER FORMAT (FOR EXAMPLE 1.75 IN TO TIME FORMAT WHICH IS 1.45 HOURS) IN MS EXCEL.

      > FIRSTLY, CONSIDER 1.75(WHICH IS IN GENERAL FORMAT) IN CELL A1. USE THE FORMULA IN CELL A2 AS =A1/24(THIS IS LIKE YOU ARE CONVERTING IT INTO HOURS). YOU WILL GET THE VALUE 0.072916667(WHICH IS GENERAL FORMAT).
      FINALLY, SELECT THE CELL A2 AND CONVERT INTO TIME FORMAT('HOME' TAB > GENERAL TO 'TIME'), YOU WILL GET THE VALUE 01:45:00.

      1. Navish, is there a way to do it the other way? If I have a time (let's say 8:30), how do I convert it to 8.5 in number format in excel?

        Thank you!

        1. Figured it out. Have four columns: A start time column, an end time column, a difference in time (hh:mm) column, and a decimal time column (hours). Format the first three as time and the last as general. For the start time and end time columns, make sure it is in military time and you have the date entered in the cell as well (it should only show the time when not clicked on). In the time difference column, do a function (use =) and subtract your end time from your start time. This should appear in "hh:mm" format. In the final column, use this equation: =CONVERT( cell ,"day", "hr"). Replace the 'cell' part with your desired time difference cell. It should look like "=CONVERT([@[Hours (time)]],"day", "hr")" in the formula bar when you are done, with a box highlighting your desired time difference cell. This should convert your time in hh:mm to hours as a decimal. I used this to add my difference in hours into a total numeric value.

          For example, lets say I volunteer from 1 pm to 2:30 pm every saturday for a month (4 weeks). that is 13:00 and 14:30 in my first and second columns (respectively) for the first four rows. In all of my third columns (time difference) for the first four rows, it should read "1:30". In my final column, it would read "1.5". I can then add my final column together to get a total of 6.

          1. You may be able to get it into three columns if you do a compound function to combine the third (time difference) and fourth (decimal time in hours).

        2. I would like to know the same thing

          1. Hi,
            This question has been asked many times in the comments.
            To convert time to decimal, multiply by 24

            =A1*24

  17. Dear
    Our worker overtime in number(6.83) we want change in hour pls solve with example

    1. 6.83 multiplied by 24 then custom format and select hh:mm

      1. My fault should be divided by 24 then custom format and select hh:mm

  18. Hi,
    Is there a way to convert from 1 to 6 digits in a column to time HH:MM:SS
    110759 11:07:59
    110739 11:07:39
    110723 11:07:23
    41727 04:17:27
    41714 04:17:14
    124 00:01:24
    106 00:01:06
    48 00:00:48
    24 00:00:24
    I use the Text to column, fixed width function but , when they are not the same number of digits in a row they do not split properly.
    Tried the Custom format by adding 0 in front of the digits and it shows 6 digits in each cell but when I try to use the Text to column it ignores the format.
    Any ideas?

    1. Try with Delimited & space

    2. this is exactly what i'm searching for help on too. would love to see if anyone knows of a way to do this.

  19. Hi Svetlana,

    I have a question,

    How can I get the difference between "1/29/2019 9:48:13 AM" and "1/27/2019 12:06:36 PM" in "HH:MM:SS" format, what formula I should use for such cases ?

    Thanks is Advance

    Vivek Wadhawan

    1. number in seconds: 1.201
      function: TIME(0;0;1.201)
      result: 0:20:01

      number in seconds: 430
      function: TIME(0;0;430)
      result: 0:07:10

    2. Hi Guys,

      Sorry, I have overlooked this question somehow. To display the difference between the two dates in hours, minutes and seconds, use this format: [h]:mm:ss

      The hour unit code enclosed in square brackets is used to display more than 24 hours. For more information, please see How to show over 24 hours, 60 minutes and 60 seconds in Excel.

      1. I have DD:HH:MM:SS and need to convert to decimal value. You're saying I have to first change to [h]:mm:ss or hh:mm:ss (somehow) and then convert? I don't see any direct way to go from dd:hh:mm:ss to decimal value in any of the formulas. hh:mm:ss to decimal is very straightforward, but adding days to it doesn't seem to work.

    3. Same question here. How do you convert DD:HH:MM:SS into HH:MM:SS ?

  20. How to convert any six digit no for example 71400 into 71° 40' 0" format in excel

    1. Hello, Mohit,

      Please do the following to change the formatting of your cells:
      - Select a cell(s) for which you want to create custom formatting, and press Ctrl+1 to open the Format Cells dialog.
      - Under Category, select Custom.
      - Type the following format code in the Type box:
      ##°##'#''
      - Click OK to apply and save the this format.

      I can also recommend you to have a look at the following article on our blog to learn more about custom formats:
      Custom Excel number format

  21. Hi
    Could you please help me with the following. My software returns an actual duration in the following way: 1 hour,30 minutes. This is returned in a single cell. However, I need to convert the output to 1.5 for example.
    Could you please let me know how I could do this.
    Many thanks

    1. Vishal:
      This will give you the result you want from your sample:
      =LEFT(I29,SEARCH("Hr",I29)-2)&"."&((MID(I29,SEARCH("Min",I29)-3,2))/6)
      Where "1 Hr, 30 Min" is in I29.
      You'll have to work with this to get the results you want in another situation.

  22. Hi,

    Thanks for the tutorial blog.

    I have a sheet wherein I will be calculating the time spent by my team member.

    Time-in will be enter in column B and time-out in column C, I will be calculating the total time spent in column D by formula =TEXT(c2-b2, "hh.mm").

    I want to highlight the column D with one color, if the time spent is more than 9 hours and with another color, if the time spent is more than 10 hours.

    What formula should I use in Conditional Formatting? Or is there any other way of highlighting the column D cells based on their values.

    Thanks in advance.
    Derok

    1. Hi,

      Just wanted to let know others, I am able to find the formula (conditional formatting) as below:
      For more than 9 hours: =CONVERT($D2,"day","hr")>216 Fill with color 1
      For more than 10 hours: =CONVERT($D2,"day","hr")>240 Fill with color 2
      For more than 11 hours: =CONVERT($D2,"day","hr")>264 Fill with color 3

      Rgds,

  23. Hello, Nice Tutorial.
    I have this , 1/3/1900 10:20:29 AM , in a a cell. I want to convert to sec 10:20:29. I don't want the date

    1. Stamatis:
      I would use the Text-to-Columns tool and in the third window select the date and the AM portions and click Don't Import option. Then format the data as Time in the Format Cells window.

  24. Sir,
    I want to convert a ten digit number to hh:mm:ss format for eg. 1505475418 to hh:mm:ss

    1. Amit:
      I found this explanation and conversions on Excel Tips from John Walkenbach.
      If you import data you might encounter time values stored as Unix timestamps. Unix time is defined as the number of seconds since midnight (GMT time) on January 1, 1970 -- also known as the Unix epoch.

      For example, here's the Unix timestamp for August 4, 2008 at 10:19:08 pm (GMT):
      1217888348

      To create an Excel formula to convert a Unix timestamp to a readable data and time, start by converting the seconds to days. This formula assumes that the Unix timestamp is in cell A1:
      =(((A1/60)/60)/24)

      Then, you need to add the result to the date value for January 1, 1970. The modified formula is:
      =(((A1/60)/60)/24)+DATE(1970,1,1)

      Finally, you need to adjust the formula for the GMT offset. For example, if you're in New York the GMT offset is -5. Therefore, the final formula is:
      =(((A1/60)/60)/24)+DATE(1970,1,1)+(-5/24)

      A simpler (but much less clear) formula that returns the same result is:
      =(A1/86400)+25569+(-5/24)

      Both of these formulas return a date/time serial number, so you need to apply a number format to make it readable as a date and time.

      I've found that the custom format m/d/yyyy hh:mm:ss works pretty well. Be sure to make your cell wide enough to accommodate the size of the value otherwise you'll get ##### displayed in the cell.
      I used the formula =DATE(1970,1,1)+A5/86400
      After I do all of this your number turns out to be 9/15/2017 11:36:58
      If you want just the 11:36:58 part you'll need to copy the 9/15/2017 11:36:58 and Paste Special/Values into another cell and copy the 11:36:58 into another cell. At this point it will be text, so if you want to do a DATEDIF or other calculation you'll need to use the first conversion for that.

  25. we have cumulative overtime data in 45:00:00 format (actually in cell it shows like 01/01/1900 9:00:00 PM)
    I want to convert it in number value like 45 (it must not in time format)

    1. Nitin:
      Have you tried to format the cell as a number?
      It sounds like it is formatted as something else.
      If formatting it as a number doesn't work try the custom format [H]:MM:SS

  26. Sir,

    I want to convert time (06:30) to number (0630) in excel.

    1. Vikash:
      I think the simplest way to convert a value that is already formatted as time in Excel is to copy the values from Excel and paste them into Word as plain text.
      When they're in Word, replace the ":" with nothing, then copy these numbers and paste them into Excel.
      When they're in Excel, format the cells as Custom format "0000" and you'll see the values displayed as you need them.

  27. I'm trying to calculate the difference between regular worked and overtime hours (hours over 40)

    I have this formula to calculate the cell of up to 40 hours
    =IF(E36=40,J36-40,0)

    all I get is "0.00" or "####################..."

    HELP!

    I then need to multiply the product of these figures by the hourly wage.

    Thank you

    1. Al:
      How is the cell formatted that holds the If statement?
      This looks like a cell formatting issue.

      1. Its a custom format [h]:mm

  28. Hi hope you will be fine,

    i want to convert number to time format and i used this formula =left(A3,2)&":"&right(A3,2) and its giving me correct time format on below number 1234,1232,3145,

    i want to know how to convert these number exe, 0123,0234,0012,0020,0003.

    kindly help me out in this regard

    1. =IF(LEN(A3)>2,LEFT(A3,LEN(A3)-2),"0")&":"&IF(LEN(A3)>1,RIGHT(A3,2),"0"&RIGHT(A3,1))

  29. I’m wanting to display 12:34 as 12.34.

    1. Winston:
      Let's say you want the original number in cell A2.
      Before you enter anything into A2 format the cell as text.
      If you want the modified number in B2 then format B2 as text before you enter:
      =SUBSTITUTE(A2,":",".")

  30. Hello Guys
    i want formula that if i put 1430 ,it should convert to 14:30. plz help

    1. Aleem:
      There are several ways to do that, here is one:
      Where original number is in A2 enter this into A3:
      =TIME(LEFT(A2,LEN(A2)-2),RIGHT(A2,2),)
      Then format A3 in the time format you want to see.

  31. Dear Excel user's

    I have entered time for 6.10 mins in Excel (i,e 6 hours and 10 mins) how to i get 310 minutes using the formula Pls help us.

    1. Dear Suresh,

      please note that 6 hours and 10 mins is 370 minutes. But if you need 310 minutes exactly and 6:10 is stored in A1, please use the following formula:
      =(A1*1440)-60

  32. How to Write 15:30 into 15 hours 30 minutes?
    i don't have any format like this in format cell- custom

    1. You can write (hh "hours" mm "minutes") in custom window, without the brackets(). I have written it just to make it look different from other text.

  33. Hi all professionals,
    could you please helping me to calculate from number to be a time, ex: 7.15 to be 7:15 ?

    Thank you in advance..

    Daovon

    1. Hi Daovon,

      The first thought that comes to mind is using the Replace All feature to change all dots (.) to colons (:). As soon as you do this, Excel will interpret your entries as times.

  34. Hi There,
    I have calculated elapsed time, but rather than excel using ":" as time separator, I want to use "h" for hours and "m" for minutes. For example: 01:50 should be displayed as 01h50m. I want to keep it formatted as a time to be able to total up elapsed times later.
    Thanks

    1. I discovered by experiment that you can use a backslash to escape the character you want to use as text in the format. So for your case the format field should contain hh\hmm\m. This works both in the custom format field for a cell and in a TEXT() function. For example, =TEXT(0.25,"hh\hmm\m") displays text 06h00m.

  35. I see an error in your formula for Converting time to hours in Excel

    =HOUR(A2) + MINUTE(A2)/60 + SECOND(A2)/360

    That last value should be 3600.
    I found your tutorial but kept getting wrong values.
    This is when I discovered that error.

    1. As Jim (post 32) has already noted in September, the formula to convert time to hours should read
      =HOUR(A2) + MINUTE(A2)/60 + SECOND(A2)/3600, not 360! It does make a difference. Could you plse change that in the text.
      Thanks, Paul

  36. I am trying to convert clock in time from a 60 minute clock to 100 minute military time. How do I convert the minute portion of the time? For example: 7:52:03am should be 7:86:03am (I need to multiply the MM by 1.66)

    1. Hello Lisa,

      To get it right and consider the AM/PM time, please use this formula:
      =LEFT(TEXT(A1,"h AM/PM"),LEN(TEXT(A1,"h AM/PM"))-3)&":"&IF(INT(MINUTE(A1)*1.66)<10," ","")&INT(MINUTE(A1)*1.66)&":"&TEXT(A1,"ss AM/PM")

      Where A1 is the cell with the original time.

      • LEFT(TEXT(A1,"h AM/PM"),LEN(TEXT(A1,"h AM/PM"))-3) gets the numeric symbols of time including AM/PM.
      • IF(INT(MINUTE(A1)*1.66)<10," ","")&INT(MINUTE(A1)*1.66) gets minutes with leading 0.
      • TEXT(A1,"ss AM/PM") gets seconds with leading 0 and AM/PM.

  37. Hi,
    I am trying to make a time-sheet for my working hours.
    i have a column with time started and time finished. The 3rd column is the difference between the 2 (hours worked for that day). I do this for every day of the week (rows). In the next column I want to sum my hours that I worked per day, but I want to use a formula. In this column I don't want to use time, but a number. What formula do I need to use.
    Example
    Start Finish Hrs worked (time) Sum hours (numbers)
    9:00 12:00 03:00 (=finish-start) 3 (=convert hrs worked)
    9:00 14:00 05:00 (=finish-start) 8 (=sum hrs above+hrs today)
    10:00 17:00 07:00 (=finish-start) 15 (=sum hrs above+hrs today)
    08:00 18:00 10:00 (=finish-start) 25 (=sum hrs above+hrs today)

    Thank you!
    Monique

    1. I am also looking for an answer to this - have you had any luck Monique?

  38. Our time is currently entered as 41:30:00 for 41 hours 30 minutes and 0 seconds. I tried using your convert time to hours formulas but I come up with 17.5 which is clearly not correct. Can you tell me what I am doing wrong?

    1. Suppose your value is at cell 'A1' then use-
      =INT(A1)*24+HOUR(A1)+MINUTE(A1)/70+SECOND(A1)/3600

  39. Hello,
    I have a column for hours, another for minutes and another for seconds:
    Hr Min Sec
    7 15 22
    7 17 25
    7 17 45
    How do I combine these into a single time formatted column?
    Time
    7:15:22am
    7:17:25am
    7:17:45am

    Thanks in advance,
    Brian

    1. HI,
      HOW DO I GET 1212 TO 12:12:00??

      1. =TEXT(F7,"00\:00")

  40. How do i change the time format from 10:00 into 10+00. (10 is the hr and 00 is the minutes.

    1. Hello Karl,

      To change the cell format, do the following. Select the cell(s), press Ctrl+1 to open the Format Cells dialog, on the left-side pane under 'Category' choose Custom, and type the following format in the Type box: hh+mm

  41. Hi
    Suppose i have some data in 40:15:00 Hrs, now i want in 40:15 Hrs, so would request you provide the formulas for this.

    Thanks

    1. try this one..I7 is your cell

      =TEXT($I7,"hh:mm")

  42. Can we convert the text "2 days 1 hour" or "3 hours 10 mins" to numerical number, measure by mins for example? Thanks.

    1. Hello, Chris,

      Please try this formula:
      =IF(ISERROR(FIND("day", A1)), 0, INT(TRIM(LEFT(A1, FIND("day", A1) -1))) * 24 * 60) + IF(ISERROR(FIND("hour", A1)), 0, INT(MID(A1,IF(FIND("hour",A1)-6<0,1,FIND(" ",A1,FIND("hour",A1)-6)),FIND("hour",A1)-IF(FIND("hour",A1)-6<0,1,FIND(" ",A1,FIND("hour",A1)-6)))) * 60) + IF(ISERROR(FIND("min", A1)), 0, INT(MID(A1, FIND(" ", A1, FIND("min", A1)-6), FIND("min", A1)-FIND(" ", A1, FIND("min", A1)-5))))

      1. Hello Maria,

        This works perfectly besides in the cases where I am missing the hours in the cell (e.g. in the cell I have only "10 mins". I am not able to figure the issue out myself. Can you please help me?

  43. Hi,

    How can I convert 42.81 into 43.21? I need to round the 42.81 into total of hours and minutes.

    Thanks

    1. Hello, Glenn,

      Sorry, we haven't quite understood your task. Could you give more details and examples?

  44. Hi guys,

    Thanks for the solutions you've shared. I found them very helpful, though I am not that 100% sure that I can get them right. I haven't tried yet some of them, and to what my concern is, I didn't find a solution to my problem still despite of all this shared solutions. Could anyone just direct me to a certain solution to my case?

    My question was, how may I convert a given sample/answer (ex: 3days 10hours 35minutes) in a certain cell into a total minutes only (ex: 382719)?

    In other words I just want to simply convert them into total minutes using 1 formula with the given sample above as: 3days 10hours 35minutes

    Many thanks,

    Adzhar

    1. Hello, Adzhar,

      Please try the following formula for your task:
      =INT(LEFT(A2; FIND("day"; A2) - 1)) * 24 * 60 + INT(MID(A2; FIND(" "; A2) + 1; FIND("hour"; RIGHT(A2; LEN(A2) - FIND(" "; A2))) - 1)) * 60 + INT(MID(A2;FIND(" ";A2;FIND("hour";A2))+1;FIND("min";A2)-FIND(" ";A2;FIND("hour";A2)) - 1))

  45. How do I return the second value from this number 00:00:24.306? When I use the Second(cell) all I get is 24. When I format the cell for 3 decimal places, I get 24.000. I would like to get 24.306.

    1. Hi Scott,

      You can use the TEXT function, for example:
      =TEXT(A1, "ss.000")

      The result of the above formula is a text string. To convert it to a number, you can multiply the returned value by 1, and then format the cell for 3 decimal places:
      =1*TEXT(A1, "ss.000")

      1. Hi
        I have a similar problem with pivot tables. I have formatted all cells with "mm:ss,000" , but when the pivot is updated to sum all time cells, it doesn't consider the decimals ...
        My use case is to sum all several time cells on a competition ... therefore decimals are important.
        Can you help ?
        Thanks in advance

Post a comment



Thanks for your comment! Please note that all comments are pre-moderated, and off-topic ones may be deleted.
For faster help, please keep your question clear and concise. While we can't guarantee a reply to every question, we'll do our best to respond :)