CharmPass is the official mobile ticketing app for MDOT MTA. For the first time ever, you can pay for BaltimoreLink local buses (CityLink, LocalLink, and Express BusLink), Light RailLink, Metro SubwayLink, MARC Train, and Commuter Bus services directly from your smartphone. CharmPass is free to download for Apple and Android devices. Download today!
When you purchase a one-way fare for BaltimoreLink local buses, Metro SubwayLink, and Light RailLink, your fare is automatically valid for 90 minutes. That's 90 minutes of FREE transfers across all MDOT MTA core services. Riders will be able to take a CityLink bus from Baltimore County to the Light RailLink downtown and onto BWI Airport for one low fare. They'll be able to take Metro SubwayLink to a station near the Inner Harbor and board the LocalLink 63 to the mammoth Tradepoint Atlantic complex in Sparrows Point. CharmPass better connects you and saves you money at the same time. It's a win-win!
90 Minutes 2 free download
To provide instruction on all of these skills, I suggest splitting up your 90-minute block into three separate parts. My preference is to do 20 min block, 50 min block, and another 20 min block. You can tweak those minutes based on the needs of your students, your schedule, or the requirements of your school.
To start your literacy block, gather students in your meeting for 20 minutes of whole-class word recognition instruction. During this time you will focus on phonemic awareness, decoding, encoding and fluency. You can begin by reviewing previously learned material and then introduce the new reading/spelling pattern you are focusing on that week. Offer guided practice opportunities and monitored independent practice with that skill. This is also a great time for dictation practice.
If you are curious to learn more about small group instruction and literacy centers, take a look at this blog post. In it, I discuss why small group instruction is important and explain how to group your students for small group instruction. I identify literacy skills to teach in small group and offer a list of science of reading-aligned resources designed for small group instruction. Finally, I leave you with a FREE, downloadable small group lesson planning template for kindergarten, first or second grade.
For the final 20 minutes, bring the students back to the meeting area and focus your instruction on language comprehension. During this time, you can build background knowledge, develop oral language, build vocabulary, and teach language structures, and comprehension skills through your read-aloud.
If time allows, I do recommend using 20 or so minutes after your language comprehension instruction to focus on writing. This is a good time to do it because as students get older their writing becomes more connected to the reading and read alouds that take place during that time.
Lastly, Acadience Reading (formerly DIBELS Next) is a great free tool that assesses essential early literacy and reading skills for students from kindergarten through sixth grade. You can use this assessment to identify students who may be at risk, identify areas to target in your small group instruction, and monitor students over time. You can download the assessment for free here.
While I think the MOD function example above is super clever, it's much more difficult to explain, and more difficult to understand for those who might later inherit your spreadsheet. Feel free to use the formula you're most comfortable with, as they both return the same result.
Hi.How to make sum of hours and minutes for school where one hour is 45 minutes, not 60.That means:1 hour and 30 minutes + 1 hour and 30 minutes = 3 hours and 15 minutes0 hours and 30 minutes + 0 hours and 15 minutes = 1 hour and 0 minutesThanks.
If 45 minutes is the equivalent of an hour, then 1 hour and 30 minutes + 1 hour and 30 minutes = 4 hours, not 3 hrs 15 minutes. In which case you can divide the sum of your times 0.75 to get the equivalent 45 minute long hours. e.g. =TIME(3,0,0)/0.75 returns 4 hours.
It sounds like your time are entered as decimals with 9.3 representing 9:30 when it should be 9.5 i.e. .5 of an hour is 30 minutes. In that case you can use this formula where cell A3 contains your time:
Hi Roro,Take a look at this file, maybe it helps: OneDriveYou can search this page for OneDrive, there are multiple downloadable samples used in comments that should help.Regards,Catalin
A3-B3 = the time differenceI am trying to fix the error when 1-8 minutes to show 0.1 of hours. In other words,1-8 = 0.19-14= 0.215-20= 0.321-26= 0.427-32= 0.533-38= 0.639-44= 0.745-50= 0.851-56= 0.957 and up= 1.0
We charge our client in 6 minutes increments. 1 minute still has to be charged as 6 minutes. In my time sheet, the time worked appears either as the time worked (5:12) or the number of minutes (312). The result I am looking for is the number oh hours I have to bill, so 1 hour is 1 and 6 minutes is 0,1. In this example, the result should be 5,2. If I had worked one more minute, the result should be 5,3.
I need to repeatedly add a block of time(for example, 7 hours and 35 minutes) to an input start time, lets say 9:18 PM today(4/20) for 24 iterations and have the correct date and time(AM vs PM) for each addition.
I have the chart all set out, but wanted to deduct the time if they took a break greater than 15 minutes. If they dint take a break long than 15 mintues then i would not deduct that time. Does that make sense?
Hi Felicity,Try this:Assuming that in cell C1 you have the total hours worked, use:=2*1.5*StandardRate+(C1-2)*2*StandardRateReplace StandardRate with the corresponding value.If this is not what you wanted, feel free to upload a sample file with details on our forum.Catalin
Hi Aizat,If cell A1 is 31/01/2017 08:00 AM and cell B1 is 03/02/2017 03:21 PM, then all you have to do is to deduct A1 from B1: =B1-A1. The cell where you put this formula must have this custom format: [h]:mm, the result is 79:14 (79 hours and 14 minutes is the difference)
I have schedule my some trips with 10:00 minutes of travel time when in actually it took 13:28 (thirteen minutes and 28 seconds) I am looking for a formula to difference between my scheduled and actual travel time in minutes.
I would like to know the formula for a time sheet an employee worked.Is it possible to auto-calculate from a paste-source for a specific time an employee worked?From 08:00 to 12:00 then the employee time out for lunch then time in at the afternoon at 13:00 and 17:00.. and deduct time worked from the time if 8:07, minus 7 minutes.
but then I would need every 30 minutes for 4 more times for the next 2 hoursexample: if the actual time continues, from above, of 7:45 am, then the next 4 hours would be 8:15 am, 8:45 am, 9:15 am, and 9:45 am
then I would need every 60 minutes for 4 more times for the next 4 hoursexample: continuation from the last time which is 9:45 amit would continue to: 10:45 am, 11:45 am, 12:45 pm, and 1:45 pm
Hi Deb,I noticed that you changed the data format from your last message, the old format was better.Type 20/08/2015 07:30 in cell A1, then type 20/08/2015 11:15 in cell B1. In cell C1, use this formula: =B1-A1. Format cell C1 as [m]. The result will be 225 (minutes)Any other format used will need other formulas to calculate the time difference, more complex.Cheers,Catalin
I am looking to make a time sheet with time in & time out rounded to a plus or minus 7 minute window grace period with a 15 min round.EX:7:53 am to 8:07 am = 8:00 am8:08 am to 8:22 am = 8:15 am8:23 am to 8:37 am = 8:30 am8:38 am to 8:52 am = 8:45 amAlso need to put into the time sheet a clock in and out for lunch that is not counted in their hours UNLESS they clock out for lunch for less than 20 minutes then they will be paid for it.The clock in and out times for lunch are not rounded times.
Great work! I have been looking at several sites for something that helps me calculating work times in hours and minutes. You are the first to show how simple it is by using the correct cell format. Many thanks! ?
Now I trying to calculate flextime which works fine as long as it is a positive result, but when it is a negative result I get the error (#####). What cell format or formula should I use? This is my formula for flextime:=E39-COUNT(E8:E38)*F4where E39 is the sum of worked hours/minutes for this month and F4 is hours per day (8) and the COUNT checks how many days I have worked on this month, i.e. have data on. I use the cell format [t]:mm for all fields.
Hi, I am trying to find a way to build a worksheet to do subtraction of hours and minutes. I have large numbers (Example 12,000:42) and want to subtract 3,724:58 from it. There are also times I will need to add similar figures. I would like to do this in excel for several reasons, for one I need to process multiple subtractions from the first number, and I would also like to be able to print the results at times. I have Excel 2013, but none of my research has led to a workable solution. Any advice you can offer would be very much appreciated.
Hi Pete,You can easily substract 3724:58:00 from 12000:42:00, you will simply deduct the cells: =B1-A1However, if they are not the result of a calculation, times bigger than 9999:99:99 cannot be typed directly in a cell, you have to use a trick for that:=SUM(12000,42,0/24,1440,86400). You have to edit only the first constants array, the second array represents hours per day, minutes per day (24*60) and seconds per day (24*60*60)The result cell should be formatted as: [h]:mm:ss to display times larger than 24 hours.Catalin
This will give you .31. Just remember this is a decimal representation of time. i.e. 31% of 1 second or 0.31 seconds, so if your result exceeds 1 minute then it will also be fractions of minutes. e.g. 1.5 minutes is 1 minute 30 seconds. 2ff7e9595c
Comments