rounding time

1. Need help with rounding multiples of minutes in Excel

Heres the situation: I am trying to create a workout spreadsheet which will show 90% of my previous best time on an exercise rounded to the nearest 15 seconds. example: A1: 00:06:00 B2: =A1*.9 this displays 00:05:24... I would want it to display 00:05:30 I have tried a number of...
2. Rounding time according to entry in a cell

I have developed the following formula- =IF(F3="","",IF(E3>="*06",ROUND(F3*96,0)/96-1/96,ROUND(F3*96,0)/96)) Which is designed to take a time in from D2, a time out from E3 and return the time difference, rounding down to the nearest ¼ hour if it is six or less minutes past the hour...
3. Calculating and Rounding Time to Nearest 15 min Interval

After finally getting my spreadsheet to do exactly what I want it to do, the payroll department made a change...grrr. Now the goal is to automatically round the time to the nearest 15 minute increment within the same cell. I also want to total these times at the end of the row to show hours...

This Week's Hot Topics

• separating multiple Proper names (uppercase letters) from a list
I have a list of proper names that only has spaces between their first and last names. I need a formula that can separate these names into...
• 'for' Loop
Hello guys, I am trying to do something new. With the help of a VBA code, in every case, last 2 Values of last 2 cells of columns D-15 to D-28 to...
• Open specific pdf in folder with vba
Hi, Below is the code in use , unable to find rich icon to put code inside using a mobile. The code in use is shown below. Everything works as it...
• What is wrong with this For Loop code?
I am trying to loop through each cell in Column U from U4 to last row to check if the percentage in the cell is greater than -.050%. In a...
• Data to match
Hi there, I have created 2 worksheets with data. First is all materials used and second has the bottle type used for each of material. How can I...
• Shifting Columns
Hi Dear Community, I'm trying to find the best way to Shift (Cut - Paste) all the information below and to the right of the "Worker" cell in VBA...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back