+ Reply to Thread
Results 1 to 5 of 5

timer a1 minus a2

  1. 07-16-2022, 10:07 AM #1
    makinmomb is offline
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    MS OFFICE 2013 PRO PLUS
    Posts
    3,718

    timer a1 minus a2

    I dont know how to get that read 6 minutes

    Find attached those on a1 and a2 , need formula on a3 to read me 6

    4:47 PM
    5:03 PM
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 07-16-2022, 10:10 AM #2
    Glenn Kennedy is offline
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2406
    Posts
    44,662

    Re: timer a1 minus a2

    You mean 00:16, I think.

    =A2-A1 and format as TIME. However if you want it to read 16

    =(A2-A1)*1440 and format as General
    Glenn



    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
    Reply With QuoteRegister To Reply
  3. 07-16-2022, 10:15 AM #3
    torachan is offline
    Forum Expert torachan's Avatar
    Join Date
    12-27-2012
    Location
    market harborough, england
    MS-Off Ver
    Excel 2010
    Posts
    4,411

    Re: timer a1 minus a2

    not possible to read 6 ......do you mean 16
    in A3 = A2-A1 then format A3 [h]:mm
    Torachan,

    Mission statement; Promote the use of Tables, Outlaw the use of 'merged cells' and 'RowSource'.
    Reply With QuoteRegister To Reply
  4. 07-19-2022, 10:17 AM #4
    makinmomb is offline
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    MS OFFICE 2013 PRO PLUS
    Posts
    3,718

    Re: timer a1 minus a2

    Glenn Thank you , that * 1440 i am hearing for the first time , ouch
    Reply With QuoteRegister To Reply
  5. 07-19-2022, 10:23 AM #5
    Glenn Kennedy is offline
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2406
    Posts
    44,662

    Re: timer a1 minus a2

    Its 24x60 = minutes in a day.
    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. Countdown timer Working BUT starting the timer repeatedly SPEEDS UP TIMER!
    By Vinospam in forum Excel Programming / VBA / Macros
    Replies: 67
    Last Post: 03-30-2019, 06:42 PM
  2. [SOLVED] Swits leading minus and put minus infront of numbers without macro
    By abjac in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-11-2015, 11:40 AM
  3. [SOLVED] How to get the correct (minus) answer for a minus raised to a power
    By enginezzz in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-27-2013, 08:44 PM
  4. How to start a Macro/Timer, then stop the timer after Pressing enter key on a Cell?
    By wrcknz in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-12-2012, 08:46 PM
  5. [SOLVED] CHANGE TRAILING MINUS TO BRACKETS OR PRECEEDING MINUS
    By Socal Analyst looking for help in forum Excel General
    Replies: 2
    Last Post: 05-12-2006, 02:20 PM
  6. Stopping a Timer / Running a timer simultaneously on Excel
    By Paul23 in forum Excel General
    Replies: 1
    Last Post: 03-10-2006, 08:10 AM
  7. how do you count a column minus dupicates minus blanks.
    By notEXCELing in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-10-2005, 08:48 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