minutes

  1. D

    Hours and minutes

    Can any help me? I am trying to finalise a time sheet. All the cells I am referring to have been custom formulated as[h]:mm At Cell S13 Ihave a formula which shows the total number of hours and minutes worked over aone week (7 day period). In Cell P2 I havethe fixed value of 36:00...
  2. Y

    Macro to unlock workbook for set amount of time

    I am new to this forum. I have been using it for research for a while but this is my first post. I have a excel test that we give to employees that should be completed in 30 minutes. I want to add a macro so that they can only have the time allotted to complete the test. It should do the...
  3. M

    Syntax problem in Query column builder, please help.

    Hello, and thank you in advance if you can help, I am trying to create a new column in a query based on two fields, PROTOCOL TYPE & DURATION MINUTES. After much online searching trying to find help with syntax and trying multiple types of formulas, I am at a loss. In my most recent attempt, in...
  4. G

    Calculating points based on time

    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...
  5. P

    VB Code to get Dashboard to refresh to get other spreadsheet information at a set time

    I'm creating a dashboard in Excel that watches an different excel spreadsheet we use for data entry. It's important that i avoid locking the spreadsheet out, I first tried using the workbook connections however it locks the spreadsheet so it cant be edited it is even set up a shared one drive...
  6. T

    Want to convert a number that looks like time to text.

    I have pasted a value that looks like "3:30" into Excel from the web. This number is actually an elapsed time and stands for 3 minutes and 30 seconds of elapsed time. As a number i would like it to be 3.5 (i.e. "three and a half minutes"). Also have numbers like 12:30, etc. meaning 12 minutes...
  7. T

    Getting Excel to recognize elapsed time instead of time.

    Trying to paste tabular data into Excel from the web. The web table looks like this. <tbody> 1 12:30 12:30 9:14 0.74 0 453 3.6 4.8 22.6 96 115 78.9 63 2 6:10.0 18:40 3:40 0.79 0 413 7.7 12.9 31.9 102 135 77.0 33 3 8:50.0 27:30 8:31 1.40 0 2,034 9.5 9.9 12.2 87 109 75.1 28 4 7:40.0 35:10...
  8. J

    How to chart an item's status with cumulative color codes over time with updates added every 3 minutes

    Hi all, I'd like to know what you all think is best way (specific details not required) to show the status of a given item over time as 3 minute snapshots. A color slot (Yellow, White, Green, Red) will be added to each interface every 3 minutes. Interace_1 YWWWWGGGGGGGGGGGGRRGGGGGGGGYWWWW...
  9. N

    A less complicated Multiple IF Statement

    Hi, I'm wondering if we can make this Multiple IF Statement a less complicated one. =if(J2="Free Minutes - New Client/Welcome Email",0, if(J2="Free Minutes - Payoff/Bonus", 0, if(J2="Internal - Not Billed",0, if(J2="Billed Minutes - Peak", H2*0.25, if(J2="Billed Minutes -...
  10. J

    Very slow saving of small xlsb file

    Hello all, i have a small xlsb file- 1.3 Mb that works just fine until i try to save it- then it blocks for about 5 minutes and i dont understand why. Can u help me with some advices? Thank you!
  11. C

    Help - Excel randomly pop a words in range every 5 minutes

    Hi, May someone help me with a VBA code for excel to pop up a word every 5 minutes in a range to remind me new vocabulary. For example i have a list of words as follows in excel: <tbody> Permeate Pummel evict behemoth rejuvenate </tbody> I would like to have Excel to pop up...
  12. L

    elapsed minutes

    Hi In this thread, Barry said "you can use [h]:mm. the same works for minutes and seconds.." No problem with hours but with minutes, I do not see how it can be elapsed. I tried this code but did not work [h]:[mm] Thanks...
  13. W

    convert minutes per km to minutes per mile

    Hi All, I am using a running app that gives me distance run, average pace per run and average pace per km. From the app, I can see my average per run, fastest per km and slowest per km. I would like to be able to convert this to per mile. The average is not difficult, just to convert the km to...
  14. N

    calculate the total time taken to complete a cycle in excel

    i need to calculate, how mant minutes its takes to reach temperature 120(T1, time corresponding to blue color numbers), after reaching 120, how many minutes it is in between 119.5 to 120.5 deg temperature(T2, time corresponding to red colour numbers), and how many minutes after T2,(T3, time...
  15. S

    Issue with Macro called macro to close WB.

    I have a WB that opens and if left open for 2 minutes runs the macro below to close it. But if I close the workbook before two minutes it still runs the macro and for some reason reopens it and then closes it. So I tried to stop the second macro from running [WbCls] by checking to be sure...
  16. G

    Text value ('## Minutes') to hours.

    I have a formula that works, but was wondering if there's a more efficient way of doing this. The challenge: Trying to parse values like "30 Minutes" and "2 Hours" and "1.5" to a time value. Formula that is working: =IF(TYPE(E2)=1,E2,IF(IFERROR(FIND("MINU",UPPER(E2)),0) >...
  17. M

    problems displaying time formats

    I'm trying to enter a duration in years, days, hours, minutes and seconds then apply a percentage and display the results as NN years NN days NN hours NN minutes NN seconds. I've applied the custom time format yy "years" d "days" h "hours" m "minutes" s "seconds" For now I'm not applying...
  18. J

    Conditional Formatting with multiple values

    I am setting up a s/sheet to keep track of meetings, if they were held, minutes received and attendance. I have set up formulas to give me the status. I want the status cell to change colour depending on its value. I would like Cancelled – Red (Got this set up already) Waiting for minutes –...
  19. S

    Quick If Then for Times

    Hey Guys, quick question. Cell R17 is a time value in hours, input by the user as "HH.h" meaning its hours and a decimal (5.5 hours for example). Cell D8 is a whole number (hours) (5 hours) Cell F8 is a whole number (minutes) (30 minutes) I'd like a quick IF Then that says IF R17 > (D8 +...
  20. theboyscout

    Subtraction by criteria

    The below example is an employee who has a previous balance ofleave. If that employee takes time off from work then that time is subtractedfrom his leave. Therefore, used hrs would be deducted from his balance. In the below scenario the employee had 23 days 6 hours and 45 minutes of leave...

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Back
Top