Results 1 to 7 of 7

Convert Decimal Hours into Minutes

Threaded View

hiddenone Convert Decimal Hours into... 03-22-2011, 02:34 PM
Richard Buttrey Re: Convert Decimal Hours... 03-22-2011, 03:01 PM
hiddenone Re: Convert Decimal Hours... 03-23-2011, 01:25 PM
mahju Re: Convert Decimal Hours... 03-25-2011, 11:39 AM
Richard Buttrey Re: Convert Decimal Hours... 03-25-2011, 12:48 PM
daddylonglegs Re: Convert Decimal Hours... 03-25-2011, 01:00 PM
hiddenone Re: Convert Decimal Hours... 03-30-2011, 02:00 PM
  1. #1
    Registered User
    Join Date
    03-22-2011
    Location
    Virginia, USA
    MS-Off Ver
    Excel 2007
    Posts
    3

    Thumbs up Convert Decimal Hours into Minutes

    I have a spreadsheet that tracks working hours by decimal hours. For example, 8hours15 minutes shows as 8.25 hours. This is tracked through a Calendar year. I then have a cell that calculates how much overtime is accrude or how much time needs to be made up. This also show decimal hours in both positive and negative answers depending on the range of hours worked. How do I convert the decimal hours into minutes to show minutes over or minutes under? I tried the below formula and anytime my answer is negative, it says #VALUE in the cell. My formula looks like this: =TEXT((SUM(E10))/1440, "mm:ss").
    E10 is the cell that contains the total decimal hours. Formula there looks like this: =SUM(C5:C214).
    Last edited by hiddenone; 03-30-2011 at 02:07 PM.

Thread Information

Users Browsing this Thread

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

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