timevalue

Hi guys, I have a column of randomly generated times using: =TEXT(RAND()*(23-10)/24+11/24,"HH:MM"). In the next column, using this formula, =IF(AND(F4>=1200,F4<=1800), "Daylight","Nighttime") I want to see if the random time falls between a "time window" and return "Daylight" or "Nighttime." I...

Hi all, I am trying to get a yes/no answer if a cell is between a time range. It is set up as a table on Office 365. I have tried IF and IFS statements with both AND and TIMEVALUE in it. I have attached a screen grab of what i'm working with at the moment. Any help is greatly appreciated. Chris

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...

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...

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...

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...

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...

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

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...

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 -...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...