+ Reply to Thread
Results 1 to 3 of 3

Convert hours:mins (formatted as date) to hour value

  1. #1
    Registered User
    Join Date
    10-20-2017
    Location
    Dublin, Ireland
    MS-Off Ver
    Microsoft Excel for Office 365 MSO (16.0.11425.20200) 32-bit
    Posts
    23

    Question Convert hours:mins (formatted as date) to hour value

    Hi there!

    I've extracted from my 20-aircraft system logs that total accumulated hours is 1325 hours and 36 minutes, formatted as date as 1325:36 [h]:mm;@.

    I'd like this number to round-up to 1326 hours as a 'number-format' i.e in the formula bar not to have 24/02/1900 05:36:00.

    See excel attached.

    At present I've been handballing these in, but if we get 40 more aircraft this will take up a lot of time and I don't think there's a way to change my output from the system logs, is it possible?
    Attached Files Attached Files

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Excel 2007
    Posts
    19,806

    Re: Convert hours:mins (formatted as date) to hour value

    As you have a blank column F, you can put this formula in F2:

    =ROUND(E2*24,0)

    or you can make it:

    =ROUNDUP(E2*24,0)

    if you always want to round up to the next hour. Format the cell as General, then copy down.

    Hope this helps.

    Pete

  3. #3
    Registered User
    Join Date
    10-20-2017
    Location
    Dublin, Ireland
    MS-Off Ver
    Microsoft Excel for Office 365 MSO (16.0.11425.20200) 32-bit
    Posts
    23

    Re: Convert hours:mins (formatted as date) to hour value

    This reply fixed my issue within 30 minutes.

    Thank you Pete_UK, reputation added!

+ 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. Replies: 2
    Last Post: 11-10-2015, 10:51 AM
  2. [SOLVED] Need Help to convert a string containing Day, Hour, Mins, Seconds to Minutes
    By aSquared in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-02-2014, 06:43 AM
  3. Convert decimal to days/hours/mins/secs
    By scaffdog845 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 02-04-2010, 09:39 AM
  4. Time Converter : Mins/Secs to Hours/Mins
    By jamesgsi1983 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-23-2009, 09:02 AM
  5. Convert Second to Hours and mins (over 24 hours)
    By Macdave_19 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-21-2009, 09:23 AM
  6. Replies: 8
    Last Post: 01-07-2006, 03:35 PM
  7. [SOLVED] How do I convert hours and mins into just minutes in excel?
    By Jsmith5663 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-17-2005, 01:00 PM

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