+ Reply to Thread
Results 1 to 2 of 2

Calculate Total hours and Round them

  1. 04-04-2023, 10:35 PM #1
    nevernine9
    nevernine9 is offline
    Registered User
    Join Date
    09-23-2017
    Location
    Toronto, ON
    MS-Off Ver
    Microsoft Office 365 Subscription MSO (Version 2310 Build 16.0.1
    Posts
    59

    Exclamation Calculate Total hours and Round them

    Greetings friends!
    Can someone help me with calculate Total Hours and Round them to 15 Minutes.
    I would like to eliminate column B & Column D in my excel sheet.

    Log In Time - Log Out Time = Rounded Total Hours for 15 minutes.

    Has anyone any idea on how to write the formula for this?

    FYR - Excel sheet is attached.

    Thank You.

    Time Rounding.jpg
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 04-04-2023, 10:53 PM #2
    Gregb11
    Gregb11 is offline
    Forum Expert
    Join Date
    02-10-2019
    Location
    Georgia, USA
    MS-Off Ver
    Office 365
    Posts
    3,122

    Re: Calculate Total hours and Round them

    I'm not sure I'm following you, but would this work?

    =MROUND((C2-A2)*24,0.25)
    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] Formula to calculate hours worked w/lunch or w/o + OT column only total after 40 hours
    By blinhart in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-31-2023, 11:14 AM
  2. Formula required to calculate Time difference between Total Hours and Hours Worked
    By pnasir in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-09-2022, 10:07 AM
  3. Calculate total hours scheduled each hours of the day
    By Trippi in forum Excel Formulas & Functions
    Replies: 23
    Last Post: 04-30-2021, 02:58 PM
  4. [SOLVED] Calculate total hours
    By sirdon in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-26-2018, 04:13 PM
  5. [SOLVED] Calculate Total Hours
    By Billy Spivy in forum Excel General
    Replies: 4
    Last Post: 02-02-2018, 11:57 AM
  6. [SOLVED] Calculate Total Hours each occurrence and Total Days for all occurences
    By CARD17 in forum Excel Formulas & Functions
    Replies: 47
    Last Post: 01-18-2017, 11:02 PM
  7. formula to calculate total hours excluding certain hours
    By Xamza in forum Excel General
    Replies: 14
    Last Post: 10-08-2014, 11:31 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1