+ Reply to Thread
Results 1 to 4 of 4

Formula to change decimal time to ..

  1. #1
    Registered User
    Join Date
    03-10-2022
    Location
    Denmark
    MS-Off Ver
    MS365 Version 2202 Build 16.0.14931.20116
    Posts
    14

    Formula to change decimal time to ..

    Hi!
    We have 2 different systems for workforce management/scheduling and HR/salary at my company.
    The WFM system (blue cells in the attached example) uses a format where 1� hours is formatted as 1,30 (Ill call this minute format)
    The HR system uses (green cells) a format where 1� hours is formatted 1,50 (Ill call this decimal format)
    The difference (orange cells) is simply System 2 - System 1.

    So far I've manually edited the HR column so they're both in minute format by calculating it manually with a decimal to minute converter.

    Is there any way to make a formula that makes the difference show up in minute format?

    Best regards
    Lasse
    Attached Files Attached Files
    Last edited by Vedes; 02-28-2024 at 10:11 AM.

  2. #2
    Forum Expert
    Join Date
    01-05-2013
    Location
    Singapore
    MS-Off Ver
    H&B2016 & H&B2021
    Posts
    3,059

    Re: Formula to change decimal time to ..

    Try, =DOLLARFR(F14,60)

  3. #3
    Forum Expert
    Join Date
    10-10-2016
    Location
    Sheffield
    MS-Off Ver
    365 and rarely 2016
    Posts
    3,212

    Re: Formula to change decimal time to ..

    I think the formula is =DOLLARFR(INT(F14)-C14+MOD(F14,1)*5/3,60)

    However 21.15-19.45 whiles you might think is one and a half hours it is actually more than this as 19.45 is 19.27 as hours and minutes!

  4. #4
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    8,587

    Re: Formula to change decimal time to ..

    Try. In T14 copied full range.
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Pl note
    Array formula should be confirmed with Ctrl+Shift+Enter keys together.
    If answere is satisfactory press * to add reputation.

+ 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. [SOLVED] Ever-elusive time to decimal formula
    By trolle in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-14-2023, 05:56 PM
  2. Need a formula to change a negative time to negative decimal
    By Renejorgensen in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-12-2016, 11:51 AM
  3. [SOLVED] Change hh:mm to hh:decimal eg 12:30 to 12.5 but already have formula for work hours in cel
    By doobynuts in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-30-2013, 03:29 AM
  4. vba to change a time value to a decimal value
    By '''your code here in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-08-2011, 02:17 PM
  5. formula to change comma to decimal point?
    By legepe in forum Excel General
    Replies: 6
    Last Post: 06-19-2010, 05:49 AM
  6. [SOLVED] How can I change time format to decimal without losing hours?
    By Bushman in forum Excel General
    Replies: 2
    Last Post: 07-16-2006, 11:31 AM
  7. Replies: 2
    Last Post: 11-12-2005, 05:40 AM

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