+ Reply to Thread
Results 1 to 6 of 6

Formula to add 24 hours in the time

  1. 09-06-2016, 11:18 AM #1
    Jomejorada
    Jomejorada is offline
    Registered User
    Join Date
    03-15-2013
    Location
    Baltimore
    MS-Off Ver
    Excel 2010
    Posts
    33

    Formula to add 24 hours in the time

    Hello,

    I would like to format a column that will automatically 24 hours to the time. Please see attached.

    Thank you in advance,

    Jocelyn
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 09-06-2016, 11:25 AM #2
    anghicole
    anghicole is offline
    Registered User
    Join Date
    09-02-2013
    Location
    Oslo, Norway
    MS-Off Ver
    Excel 2013
    Posts
    44

    Re: Formula to add 24 hours in the time

    Like this?
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  3. 09-06-2016, 11:31 AM #3
    The_Snook
    The_Snook is offline
    Valued Forum Contributor
    Join Date
    09-09-2009
    Location
    Liverpool, England
    MS-Off Ver
    Excel 2021
    Posts
    1,013

    Re: Formula to add 24 hours in the time

    Hi Jomejorada,

    Try this in cell D2 and copy it down:

    =ROUNDUP(A2,-2)+B2

    Regards,

    Snook
    Reply With QuoteRegister To Reply
  4. 09-06-2016, 11:35 AM #4
    Jomejorada
    Jomejorada is offline
    Registered User
    Join Date
    03-15-2013
    Location
    Baltimore
    MS-Off Ver
    Excel 2010
    Posts
    33

    Re: Formula to add 24 hours in the time

    Hi Snook,

    I'm finding that there are some that give incorrect results using the same formula. Please see attached for examples.

    Thank you,
    Jocelyn
    Attached Files Attached Files
    Last edited by Jomejorada; 09-06-2016 at 11:57 AM.
    Reply With QuoteRegister To Reply
  5. 09-06-2016, 11:43 AM #5
    Jomejorada
    Jomejorada is offline
    Registered User
    Join Date
    03-15-2013
    Location
    Baltimore
    MS-Off Ver
    Excel 2010
    Posts
    33

    Re: Formula to add 24 hours in the time

    Yes but Snook already sent me the formula. Thanks!
    Reply With QuoteRegister To Reply
  6. 09-06-2016, 11:59 AM #6
    Jomejorada
    Jomejorada is offline
    Registered User
    Join Date
    03-15-2013
    Location
    Baltimore
    MS-Off Ver
    Excel 2010
    Posts
    33

    Re: Formula to add 24 hours in the time

    I used the RoundUp formula and it worked on some but not on others? Attached.


    Please help.

    Thanks,
    Jocelyn
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Timesheet that calcs time in, time out, lunch used, reg hours, ot hours, double hours
    By noobface in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 08-21-2021, 03:45 AM
  2. Formula for Timesheet - Double Time, Time Half and normal Hours
    By Tracs13 in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 09-12-2017, 09:40 PM
  3. [SOLVED] Formula to get the worked hours from time A to time B.
    By ShadowHash in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 11-14-2015, 07:33 AM
  4. [SOLVED] Formula to fill C5 with a time that makes J5 equal 8 hours based on time put into B5
    By possumbarnes in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-26-2015, 10:08 PM
  5. Time during business hours (week days) and time during Out of Hours (weekdays+weekends)
    By wintheranders in forum Excel General
    Replies: 2
    Last Post: 11-12-2014, 11:56 AM
  6. [SOLVED] Formula to Calculate Normal Hours, Time & 1/2 & Double Time from Daily Hours per week
    By KazzICC in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-17-2014, 01:51 AM
  7. template or formula for start time -finish time -total hours ple
    By cc in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 03-27-2006, 01:10 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1