minutes

I have a sheet that I have taken seconds and converted it to minutes. simply took the seconds / 60 to get a number. Need to determine based off those minutes how many 30 minute increments there are in a given number. For instance 66 minutes would be 3 segments. Any help would be greatly...

Hello, I have a sum of hours in [h]:mm and need to convert it to Days Hours Minutes. Just selecting a different format doesn't work (ridiculous! :nya:) but understandable. INT and MOD I've used before but in some cases it will make say 26 hours as one day and one hour when I need it to be 1...

Hi All, I'm experiencing a problem where power query slowed down after I merged two tables. Since the merge, each time I do a step, it appears its recalculating or refreshing something in the back ground. the refresh stops when it reaches 120MB which takes about 5 to 10 minutes. So basically...

Need to convert something like: 4 Days 16 Hours 32 Minutes to something that can be added up or manipulated. Minutes is fine.

What is the formula for getting the minutes between two dates Considering network days (Mon to Fri) and working hours (8am to 6pm)

Hello Clever People, I have another query for you that is probably so obvious you'll have me as a fool. Anyway, onto my "problem". I'd like to create a formula to enable me to convert units of time to hours and minutes. The units of time are blocks of 6 minutes. So 10 blocks = 1 hr (or) 60...

How would I convert seconds displays as 10ths to Minutes? Would it be 34543 /10 /60 ?

Hi, I hope you're doing well. I was looking if you could help me to create a macro with the below condition; 1) Start Timer (for 5 minutes) & the Stop Timer(seems to be not working, need help to make it work), 2) If the Stop Timer button is clicked, then the Start Timer button should be...

Can anyone tell me how I might do the below multiple part scenario: I need to subtract an end time and a start time to get the hours and the minutes. Start time is in P2 and end time is in Q2. I wanted to do this in a way that I actually don't need to enter the colon and could just enter the...

Hi. Please see link to the relevant file, below: https://1drv.ms/x/s!AtIvkRgReIvwgRPV4fmLEL1-gjz- I have a problem that I can’t seem to solve. I have this list of times and positions, with the times in hh:mm:ss format. However, the times have the minutes and and seconds in the wrong...

Hi Team, I have a data as below, im looking for a formula to convert minutes in to hours i would require the result as mentioned in column B. Please could you help? <colgroup><col><col></colgroup><tbody> Column A Column B Result required 21 0.21 56 0.56 48 0.48 68 1.08 </tbody>

I have a column of minutes from goals scored 45' 5'67'89' 2'5'89' 15'67'79'78' is there a way of adding them all up please?

Hello, I need to calculate time based on a measured output in a table. Basically I'm try to generate a standard amount of time per output. The rules are: 0 to 1 is 20 minutes flat (even if 0.1 is delivered or 0.9 it's still 20 minutes) and every unit after that is 10 minutes per unit (if 2.3...

Hi All, I currently have the below formula: =IF(AND(R2="c",MATCH(D2,'Activity Report'!$A$3:$A$8),MATCH(B2,'Activity Report'!$C$3:$C$8)),"Confirmed","False") The Cell B2 and the column of C in the Activity Report are time and dates, formatted as (dd/mm/yyyy hh:mm:ss). Effectively, when I am...

Hopefully I can explain this well enough for someone to help me. I track stats for a basketball team, and am looking to sum up the total minutes every particular lineup of players is on the court. This data would be on a new worksheet as since we have 12 players on the team, if I calculate it...

In my code, I run into values of a variable (tdur) representing duration (in hours) . These are some examples: 0.53 1.53 2.11 1.06 1.32 2.64 0.26 I would like to round these to the nearest 30 minutes. So, with these example: 0.5 1.5 2.0 1.0 1.5 3.0 0.5 I thought it was more simple than it is.

Hello, I am trying to create an Excel file that will scrub the output of a program I use (excel file output) into the format of the input I need for a different program. My issue arises when the output file will put the minutes of an employee into various columns of the same row based on...

Good morning, I have a cell that contains the following value: 01/01/1900 06:58:27 which equates to 1 day 6 hours and 58 minutes. Is there any formatting sequence I can use to get the cell to display "1d 6h 58m", rather than the "30h 58m" that I have at the moment, using [hh]"h" mm"m" I'm using...

Hi, I presently have a workbook that numerous individuals can access but I need it the Workbook to automatically close after 20 minutes. I have entered coding and the workbook does close but regardless of the time I insert, it closes after 2 minutes Private Sub Workbook_Open()...

Hi, I have 2 columns. Each column contains a date & time in "m/d/yyyy h:mm AM/PM" format. I am trying to subtract the differences between two columns and am having a hard time. Any assistance appreciated and the desired result format is negotiable, so long as i get minutes difference....3...