+ Reply to Thread
Results 1 to 3 of 3

Converting [h]:mm:ss to hours in decimal

  1. #1
    Registered User
    Join Date
    03-19-2019
    Location
    Mexico
    MS-Off Ver
    Office 2016
    Posts
    7

    Converting [h]:mm:ss to hours in decimal

    Hi guys. I'm having the next problem, I have several values that show me the total time that certain equipment is in use in a week, due to the fact that my data base gives me the total time of all my equipments it gives me a big number.
    For example, I usually have this:

    A1: 2653:45:00
    B2: 2653.75
    B2=A1*24

    No big deal, this simple formula usually do the work. But my problem is the next one:

    A1: 10616:12:00
    B2: #¡VALOR! (VALUE for my non spanish speaker fellas)

    I would appreciate your help, have a nice day
    Last edited by AngelJD25; 03-20-2019 at 01:39 PM. Reason: solved

  2. #2
    Forum Expert XLent's Avatar
    Join Date
    10-13-2010
    Location
    UK
    MS-Off Ver
    various
    Posts
    1,913

    Re: Converting [h]:mm:ss to hours in decimal

    HI, would below work for you?

    Formula: copy to clipboard
    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    03-19-2019
    Location
    Mexico
    MS-Off Ver
    Office 2016
    Posts
    7

    Re: Converting [h]:mm:ss to hours in decimal

    Quote Originally Posted by XLent View Post
    HI, would below work for you?

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    It does, thank you! Greeting to the UK

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Converting hours/min to decimal time
    By Lunaki in forum Excel General
    Replies: 10
    Last Post: 06-04-2017, 02:32 PM
  2. Converting decimal to Month:Day:Hours:Minutes:Seconds
    By KellyK in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-20-2013, 03:34 AM
  3. Replies: 13
    Last Post: 05-03-2013, 08:42 PM
  4. [SOLVED] converting decimal hours to regular time but longer than 24 hours
    By rkruse in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-21-2013, 07:45 PM
  5. [SOLVED] Converting hours and minutes to decimal hours
    By Calandra@Seohan in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 07-25-2012, 05:25 PM
  6. [SOLVED] Converting a decimal time into hours and minutes
    By LizHough in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-04-2006, 06:10 AM
  7. converting a decimal number to hours and seconds
    By jeda67 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-04-2005, 05:40 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1