timevalue

  1. O

    Application.OnTime TimeValue

    Hi everyone. I have this command "Application.OnTime TimeValue" on my workbook while it is open. I just like to know if that command will continue it's assigned task based on the time given on everyday basis or just the day that the workbook is open? Thanks Application.OnTime...
  2. F

    SelectionChange VBA Code Help, conditionals and time values OR use comma separated string of integers to select cells in a column

    tldr: I need code that, on selection of any cell in F8:F27, will add cells corresponding to the numbers from the third position of the comma separated string where cell E10 is the first number and E29 is the 20th number, so selecting F8 will add E10, E11, E12, E14, E15, E21 and E27 to the active...
  3. A

    TimeValue in Macro linked to cell in worksheet

    Hi I have the below progress bar which goes from 10% to 100% changing every 2 seconds and runs in the status bar. This works fine.. I run 12 main macros that need the progress bar to run and each macro will have a variable amount of records to process, and changes each time I use the...
  4. GomaPile

    Split & Convert Shift Time into TimeValue

    Hi all, Can someone please help... If possible, I would like to avoid using extra cells to convert a Shift Time displayed in a single A1 cell for a Roster. Is there a way to split & convert the shift time 0630-1500 ED1 and ignoring 'ED1' letters at the end. It will help me to use this...
  5. L

    Macro Wont Run When cell is selected ... Application.OnTime EarliestTime:=DownTime

    Hi all, I have a workbook that we use in work in work with a timer function that shuts down the workbook when the workbook hasn't been used for 15 minutes. However, if my peers select a cell and go into edit mode then no macros run and then they go home so no one can edit it. Is there a...
  6. V

    Need technical understanding on Formula

    Pls teach me how this formula works.. DateValue and TimeValue
  7. D

    Ontime Event Going haywire at midnight

    Hello! I have a excel project that starts an ontime event on workbook open. This thing works fantastic! However, when midnight rolls around it crashes. After doing some research I have surmised that the problem is when the date changes, the time is now After the initial time set. I tried to...
  8. R

    Deriving a live TIMEVALUE from the NOW() function

    Hi, I'm currently building a data model for my work, I've built a giant =IFS statement to return a value based on the current time: =IFS(AND(F3>=TIMEVALUE("00:00 AM"),F3<TIMEVALUE("00:15 AM")),"00:00 - 00:15",AND(F3>=TIMEVALUE("12:15 AM"),F3<TIMEVALUE("12:30 AM")),"00:15 - 00:30" ... "23:45 -...
  9. B

    VBA Macro for shifting between two workbooks (or windows)

    Good day! I am a beginner when it comes to Excel Macros/VBA. I have a project that it is already done except for one part: I need to program it such that excel shifts between two workbooks every minute. Any tips or advice will be appreciate it as I have tried many things and I have failed...
  10. K

    Application.OnTime TimeValue

    Hello I have written a macro for work that needs to execute every weekday. It works well, but every time that I'm not in the office, it don't execute. So for example if i'm off on Wednesday, Thursday morning it didn't run. Also, I don't know how to include that it only runs on a weekday. I have...
  11. F

    Importing timestamps with milliseconds

    I try to import an instrument log with timestamps in format YYYY-MM-DD hh:mm:ss.sss into Excel. Whenever the first digit after the decimal separator is a zero, Excel doesn't recognise the value as valid date time, but import it as text. E.g. "2014-11-27 03:38:34.853" is imported as time, but...
  12. B

    How display timevalue

    I want to get the correct information according to the following table <tbody> A B C 1 Albert 00:20 5*00:20 2 Bertie 00:45 5*00:45 3 Charles 00:25 5*00:25 </tbody> Without using VBA How can I get the information on Column C? I don't want to get 5*0,0138888888888889 neither 01:40. I...
  13. B

    Vlookup using TIMEVALUE

    I'm trying to identify which employees work at day, at night or during circadian time. Without using VBA is there any formula in excel to this? In this example I have the result I want to get at Identification (Column D). The conditions are above (A17). The most important is: 1 circadian...
  14. B

    Vlookup using TIMEVALUE

    I'm trying to identify which employees work at day, at night or during circadian time. Without using VBA is there any formula in excel to this? In this example I have the result I want to get at Identification (Column D). The conditions are above (A17). The most important is: 1 circadian...
  15. A

    fill in Date and time where missing on 3 minute interval.

    Hi I am having trouble getting a VBA code to do the following: 2012/05/01 00:00:00 2012/05/01 00:03:00 2012/05/01 00:06:00 2012/05/01 00:15:00 2012/05/01 00:18:00 From this above to this below 2012/05/01 00:00:00 2012/05/01 00:03:00 2012/05/01 00:06:00 2012/05/01 00:09:00 2012/05/01 00:12:00...
  16. R

    Excel MVP's - VBA Code Optimization Request

    I was helping out another forum member with a solution to the following problem: http://www.mrexcel.com/forum/showthread.php?t=596276 I created a working code solution, but it has to be optimized. Can one of the VBA experts out there make some suggestions to significantly speed up this code...
  17. C

    Need to find specific time value in one column, then use data from that row in a formula

    I'm hoping one of you brilliant minds out there can help me out. I'm brand new to VBA, and am currently stumped by this step in my macro. I have been given the task of importing a text file system log into excel, weeding out the data that I need, putting a timestamp on each entry, and then...
  18. L

    How to use cell reference for TimeValue in VBA

    Hello all. I would swear that I have seen this kind of syntax for ontime somewhere: Application.OnTime TimeValue([A1]), "colorbg_macro" But if I try to use it, a Type Mismatch error 13 appears. If I use a real time value like next one the function works: Application.OnTime...

Some videos you may like

This Week's Hot Topics

Top