hour

Hi Is it possible to make slicer for 12 hour period from 6am to 6pm and 6pm to 6am? If so how would I do this Any help would be greatly appreciated Thank you Craig

I have a fairly simple pivot table which shows call center data in a very useful and intuitive way for managers. Below is the sum of the number of calls for a given hour and day of the week in March. What I need to show is the average of the calls received for a given hour & weekday (word...

RE: Displaying a Msgbox 1 hour after the workbook opens This code is in the Workbook Open() event: Private Sub Workbook_Open() If Day(Now) = 10 Then MsgBox "Good morning" else End if This works great but displays the MsgBox as soon as soon the workbook is opened. How do I get the MsgBox...

I have a file that contains values gathered at 15-minute intervals for an entire day for hundreds of meters. I need to sum these values by each hour for each meter. Most of the entries contain values for each 15-minute period in the each hour (0:15, 0:30, 0:45, 1:00), but not all show all four...

Hi all, I have a list of activities that include the start and end time - I need to sum the duration of these activities into a table with hourly intervals. It would be easy enough if all the activity was only an hour in duration :laugh:, however there are activities that are an hour and 30...

Please forgive my appalling lack of Excel vocabulary. I'm not even sure what what I'm trying to do is called. :) I have a spreadsheet to track the time and frequency of occurrences, say phone calls. My data is like: Weekday Date 9:00 hour 10:00 hour 11:00...

Hi, I need to be able to summarise the table below to show who was doing what hour by hour so that this can be used in a database. Essentially I need to extract an hour by hour view from the large table below to just return this: <tbody> 08:00 name.1 SALES 2 08:00 name.4 TRAINING 08:00...

I'm trying to count how many items have been sold each hour from a report. In example below between 10:00pm and 11:00pm I sold 4 items. I need to do this for each hour. How do I do a lookup for a time range? Thanks in advance! TIME Items Sold 10:41:00 PM 2 2:42:00 PM 1 4:36:00 PM 1 8:02:00...

I'm trying to round to the nearest quarter hour but if the rounding is less than 1:15 I want the cell to just display 1:15 I've tried =IF(CEILING((B2-A2),"00:15")<"01:15","1:15",CEILING((B2-A2),"00:15")) and it just puts 1:15 is every cell no matter if it's above or below 1:15 Below is an...

Hi! I have an excel file that is saving every day. I could save it an hour but not 'every' hour because of the error with the filename. Is there a way to just have a file which is updating every hour until it reaches a whole day and automatically save it with the same file name? Thanks

I would like to make a formula stating below: worker finishes work at 18:00, after 18:25, we give half an hour OT after 18:45, we give 1 hour OT I also need to take into account some workers might work a few hours OT, therefore if he finishes work 19:25, I need excel to show 1hr30minutes OT...

I'm not an advanced excel user, and there is probably a very simple formula for this, but I am wondering if there's a way to record the value of a cell at a certain time. I'm a writer and I track my word count progress (cell C11) for each hour of the day. Right now, I'm putting it in manually...

I'm trying to get a formula that calculates points up to a maximum of 50 depending on how many minutes a result is. IE Cell A2 has an actual time in it Cell B2 has a guess time in it Cell C2 has a calculation which shows as points (spot on, 50 points, 1 minute under or over, 49 points, 2...

Hello All, I have been searching for the last hour and I cannot find anything on how to add a slicer to a Ribbon Menu. Is it possible? Kurt

OK I am figuring the difference in times and the result is a decimal. But if the result is over an hour I loose that time, I only end up with the minutes and loose however many hours. So ... I need to fix that. Here is the existing formula...

Hi. there are lots of videos online teaching gantt chart with scheduling (by hours and minutes). but I haven't found anything about inserting break hour (lunch hour) Is this doable? can anyone guide me where to find it? Thanks

Hi, I want that when I copy and paste time in Column C, an extra hour is added automatically. I mean if time is 7:35, when paste time will automatically be 8:35. This is about starting the second half of a soccer game. https://yadi.sk/i/69TRVQvw8zVzoA

I have a field on that table that in excel is defined as custom H:mm. It is a duration of session field. The data will be 1:00 or 00:30, for one hour or 30 minutes. In the Crystal report it is showing as 12/31/1899. This is a downloaded excel from a report in the EHR.

Hi All, I'm not familiar enough with error handling in VBA, so I'm trying to figure out the best way to handle this. I did a little searching and found an On Error Goto that might work but I don't think that will be the best solution here. I have 18 worksheets, each worksheet as a Pivot...

Hi All I think this is a question to test the chaps who specialise in difficult formula I am working on something that requires me to adjust tide times from UTC to a format that accommodates the seasonal changes in the UK for British Summer Time. Below is an explanation from the UK Government...