minute

Is it possible to convert 323584 seconds into Hours, Minute, Seconds?

I'm trying to create a user form with 2 levels of selecting on the 1 form. User can chose option ShotGunStart or TeeTimeStart. If they chose TeeTimeStart, then they can select 8,9 or 10 minute spacing. o ShotGunStart o TeeTimeStart o 8 minute spacing o 9 minute spacing...

Hello, I am having problems calculating with function "COUNTIF". According to the given data I am supposed to calculate the number of calls for each minute in the Busy hour(60 minutes) using "COUNTIF" function in excel. https://imgur.com/a/f89ayMm For example - if I take minute number 2...

I've written 3 macros to produce my charts. Only the hourly chart will run. the other two macros show an error for the 15 minute and 30 minute. I'm not sure how to properly define the time for these two macros. I've tried quarter- and half-hourly ... I've tried using 15 minute and 30 minute...

I have a start time (BG13) and a finish time (BH13) which could contain any start and finish time (even start time today, finish time is tomorrow)..... is it possible to count how many 30 minute blocks are between (and including) those times? as example 5:30am start, 7:38 start (it is 2 hours I...

Hi! I'm trying to compile a total time for a job by referencing the name of the job's component. I'd like to be able to assign a value of 1 minute to "filing", 2 minutes to "retrieval", 1 minute to "processing", etc. and have the time compile based upon the job entered in the column. I...

I apologize in advance for the novel that follows I have created a technician break schedule for a project that can run 20 hours or more. The schedule is dynamic in that it will expand to the number of technicians that are onsite on any given day, which varies from day to day. The technicians...

<style type="text/css"> Page { margin: 2cm } p { margin-bottom: 0.25cm; line-height: 115% } </style>I have 2 columns ofdata, the First is a list of Times in HH:MM:SS format and the SecondWeb sites visited, I need a formula that reads the time columnminutes and counts the number of web sites...

I have 2 lists of data 1 with 1 minute data and with 5 minute data. ordered like this : |29-12-2017 18:00:00| I would like to turn my 5 minute data into 1 minute data. Basicly inserting the same row 4 extra times beneath the first adding for each row 1 minute |29-12-2017 18:01:00| Or...

Hey everyone, For a project at Uni I'm analyzing a big package of Data. (Not allowed to go into to much detail about the data.) Currently im trying to analyze the data using VBA in Excel. However I've never programmed in my life. For the past week I've been trying to make VBA do what I want...

What I want to do is make a chart like this: That shows score and when they happen. So a team score a goal at the 3 minute mark, their margin goes up 6 points, then a point at the 5 minute mark, they go up to 7 points, then at the 14 minute mark the other team scores a goal and it goes back to...

Hi I'm using code that allows me to update cell A1 with the current time every x seconds. However, is there any code that will take the computer time and update the clock when the minute changes over. Basically, I don't want the workbook saving every 1 second in order to make the time be...

I export reports and i receive a number format that I need to edit. What i get is: <style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>2.5 hours (150 minutes) what I would like to replace it with is just the minute amount 150 Have a look at...

Hi, I looked on site but the example did not pertain to what I need. I presently am using many "helper" cells. I have a stock feed provider where I get live intraday quotes. The problem is that it can only provide quotes in 1 interval at a time. For example, I can only get 5 minute data...

I have a dashboard that loads in a lot of information from a data base and does various amounts of manipulation. The entire process takes 2 minute. I have the spreadsheet set up to automatically to re-calculate every 30 minutes or so to import all the new data. When the sheet recalculates I'd...

Hi Team, I have seen one post where in dates column. hours and minute to remove and format the date. I have one question if the given date is in text format, 2017-08-10 : 04:30 , what would be the code, to remove hours and mintues from it. I have similar kind of situation , One of my...

Hello, I need to fill in a table by matching the vertical number in Column J with the horizontal number in Row 3 and then entering a 1 if they match or blank if they do not match. I've added a 1 at the intersection of N4 because both the vertical and horizontal numbers are 31494. Table looks...

Hello, I need to fill in a table by matching the vertical number in Column J with the horizontal number in Row 3 and then entering a 1 if they match or blank if they do not match. I've added a 1 at the intersection of N4 because both the vertical and horizontal numbers are 31494. Table looks...

I am trying to do something (I thought) was very simple - chart the time of day a task is done vs. the amount of time that the task takes. I have start and stop times. I subtracted them and got the time between. I even converted it to minutes and rounded it to the nearest 10 minutes. The...

I am trying to calculate the minutes from a cell after removing the hours. This formula should work but the results are wrong. Formula I am using: =INT(((I7 * 24) - INT(I7 * 24)) *60) & " mins" If cell I7 has 8:04 I get, "3 mins" If cell I7 has 8:00 I get, "-1 mins" This should be simple so...