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

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

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

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

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

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

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

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

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

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!

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

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

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

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

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

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) >...

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

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 –...

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 +...

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