+ Reply to Thread
Results 1 to 3 of 3

Current Time Calculations

  1. #1
    Registered User
    Join Date
    02-26-2022
    Location
    California, USA
    MS-Off Ver
    2019
    Posts
    1

    Current Time Calculations

    I would like to do some math on current time:

    I would like to have a cell which calculate current time is over a 15-minutes interval.
    e.g.
    (1) If current time is 4:05, it is 5 minutes pass 4:00. The cell shows 5
    (2) If current time is 4:12, it is 12 minutes pass 4:00. The cell shows 12
    (3) If current time is 7:23, it is 8 minutes pass 7:15. The cell shows 8
    (4) If current time is 5:59, it is 14 minutes pass 5:45. The cell shows 14
    (5) If current time is 6:33, it is 3 minutes pass 6:30. The cell shows 3

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft? Excel? for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,003

    Re: Current Time Calculations

    Try

    =MOD(MIN($A1),(15/1440))
    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

  3. #3
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Current Time Calculations

    ...or

    =MOD(A1*1440,15)
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

+ 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] Get Next Event Time Based on a Fixed DateTime, the Current Time and a Time Multiplier
    By nicoan in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-22-2021, 01:41 PM
  2. Replies: 4
    Last Post: 02-14-2018, 03:52 PM
  3. compare time values - current time with time in cell range?
    By wyattea in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-13-2013, 11:28 PM
  4. Code to insert current date (but NOT current time)
    By mjwillyone in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-13-2013, 09:37 AM
  5. make calculations to current cell
    By t_granat in forum Excel General
    Replies: 2
    Last Post: 08-27-2012, 04:30 PM
  6. [SOLVED] add current time (hh:mm:ss) as well as current date (dd:mm:yyyy) into the code
    By papasideris in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-28-2012, 02:29 PM
  7. [SOLVED] Can I automatically enter the current date or current time into a
    By Ben in forum Excel - New Users/Basics
    Replies: 7
    Last Post: 10-19-2005, 11:05 AM

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