time between

Hi I am trying to compare two lots of times and got as far as the code below. In Cells A1, A2 and A3 I have three times in the format +02'00... and in Cells B1, B2, B3 I have three times in the format 00:17:00. If the time in Column A are greater than the times in Column B I want a Yes in...

I have different times in Column (A), what i and trying to do is. If the Time is between 6:37am and 2:36pm return Days If the Time is between 2:37pm and 10:36pm return Afternoon If the Time is between 10:37pm and 6:36am return Nights Can someone help? thanks

Hello, I have been reading for hours and i have not been able to find someone who can answer why the time on the excel status bar is correct and my column sum is not. The column sum is adding minutes which I cannot figure out. I also need to sum the hours to the nearest 15 minute increment. I've...

Trying to solve a time issue. <tbody> A B C D E Arrival time Unload date Unload complete Completed Total time 11:30 02-okt 02-okt 12:30 10:30 02-okt 03-okt 9:30 13:00 06-okt 09-okt 8:00 </tbody> I want to be able to get how many hours from Arrival to completed my order has taken...

I've been struggling with this for some time. I have large quantities of data where I'm given a start and stop time. I need to count minutes used by hour. Ex: Start 17:30 End 20:05 Outcome 17:00 = 30 18:00 = 60 19:00 = 60 20:00 = 5 Right now I have column A as my start times, B as my end...

is it possible to use dates in a formula to activate a formula and then at a designated time stop the formula from working but keep the results of the last recording? I have a report that I pull data from on a monthly basis. what I would like is for the report to automatically pull all the data...

Hi all, I'm trying to find a dynamic way to get the top 10 books used in a library based on the length of time they've been checked out. The entries are logged with a date/time stamp via a command button on a form. The people have the opportunity to check in and out three books at a time. I'm...

Hello everyone, hoping you could help me out. Currently I have a line of code in a macro: Application.Wait (Now + TimeValue("00:04:00")) In this example the application will pause for 4 minutes. I was wondering what I would have to do to randomize that time value, say anywhere from 1 to 10...

Not quite as simple as the title says. I'm trying to get the timesheet to add up the hours worked. There are several on off's throughout the day / night shifts, each time entry comprises of an hours cell and a minutes cell. <tbody> Hrs Min Hrs Min Hrs Min Hrs Min Hrs Min Hrs Min Hrs Min Hrs...

Hello All, We use Avaya for our time tracking that records our technicians login/logoff time on the phone. I can get a report that shows their login/logoff punches as well as the total time for that day. My staff has a hard time figuring out 100'ths for minutes which is what Avaya records the...

Hi, I have 205 (general format) in cell C13, 171.08 (general format) in C14. 205 is 205 hours, 171.08 is 171 hrs 8 minutes. To subtract these I an using the following-> =SUBSTITUTE(TEXT(D13,"00.00"),".",":")-SUBSTITUTE(TEXT(C13,"00.00"),".",":"). My result is -9:52 (format h:mm). It should be...

I'm trying to make a cell automatically return what the current shift is, for example if it is between 7:00 am and 3:00 pm return 1st shift, between 3:00 pm and 11:00 pm 2nd shift and 11:00 pm to 7:00 am 3rd shift. All I want to see in the cell is 1st, 2nd or 3rd shift when it is within their...

Hello! What would be a formula to check multiple times and print a different result depending on the time? They're very specific times: If it's less than 10 minutes, print 1.5 If it's greater than 10 but less than 30 minutes, print 3.0 If it's greater than 30 minutes, print 5.0 Thanks so much...