+ Reply to Thread
Results 1 to 4 of 4

Converting time in excel

  1. #1
    Registered User
    Join Date
    04-02-2015
    Location
    Banchory, Aberdeenshire
    MS-Off Ver
    2013
    Posts
    2

    Converting time in excel

    I'm working on a time sheet.
    I have hours worked in decimal eg 7.5
    I also have negative -7.5

    How do I convert this into 7:30 and -7:30??

    Many thanks

    Emyr

  2. #2
    Forum Contributor
    Join Date
    01-28-2014
    Location
    Turkey
    MS-Off Ver
    Excel 2013
    Posts
    159

    Re: Converting time in excel

    You can use negative times if you switch to the 1904 date system

    Please Login or Register  to view this content.
    Custom format result cell as hour
    Last edited by Ali Kırksekiz; 04-02-2015 at 10:26 AM.

  3. #3
    Registered User
    Join Date
    04-02-2015
    Location
    Banchory, Aberdeenshire
    MS-Off Ver
    2013
    Posts
    2

    Re: Converting time in excel

    Thanks
    I've tried that and it works, some think that it may cause problem when sharing document with others?
    Regards

    Emyr

  4. #4
    Registered User
    Join Date
    08-31-2011
    Location
    Stamford, CT
    MS-Off Ver
    Excel 2013
    Posts
    30

    Re: Converting time in excel

    How about this?

    =TRUNC(A1,0)&":"&TEXT((MOD(A1,1))*60,"00")

+ 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] Converting Time into Number and Dividing in Excel
    By newbie4 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-22-2014, 04:43 AM
  2. Replies: 2
    Last Post: 07-22-2014, 09:20 AM
  3. [SOLVED] Converting an elapsed time in decimal number format to an actual time :S
    By Spicey_888 in forum Excel General
    Replies: 3
    Last Post: 07-20-2014, 08:53 PM
  4. Converting 4 digit number to time unit and extrapolating time to run from there
    By shaunsul in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-31-2011, 08:01 PM
  5. Excel keeps converting my %s to Time format
    By Michael Deathya in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-11-2006, 04:40 PM

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