time

1. How to check if a 2 specific time falls in between 2 times (Shifts) in Excel?

1.I want to find out if an event with start time and end time falls "inside" or "Outside" working shifts for associates. 2.Segregate and calculate the production duration that falls within shift hours or outside shift hours. (The Shift timings are 5pm to 2am which would be the next day so that...
2. How would I convert time values to words?

Hello. I have a workbook I created to track break times at my work. I have a column of times in a workbook in the custom format [h]:mm:ss. Example 0:06:00 for six minutes. This column tells us how long the person went over the required break time. I would like to, in another column display this...
3. mm:ss formatting

Does anyone have a solution to formatting mm:ss without the AM/PM after it. I'm creating a spreadsheet where I need to put time as an input, say for a race where something like 10:30 would be 10 minutes and 30 seconds. There are then some calculations done on the time which says if time is below...
4. Spread cost over time using multiple dates

Hi Guys, I am currently trying to put a sheet together that will automatically spread cost over time using multiple date sets. I have the formula working for one set of dates however some items need to be spread across more than one activity i.e. up to 4 sets of dates and i was wondering if...
5. Convert Cumulative Time / Time Duration to Text or String

I have a Cumulative Time field that formats as [h]:mm:ss that aggregates time in hours. I am needing to extract the time portion to convert it to a Text or String value. For example, a cumulative time total of 95:31:00 shows as "1/3/1900 11:31:00 PM" in the formula bar which is not what i want...
6. Convert Text To Time

Hi I have received a spreadsheet from a colleague which has the time showing as 1:30pm and so on. The cells are formatted as General and no matter what format I try, I have not been able to convert the cells to show 13:30 etc. I even tried =TEXT(B2,"HH:MM") to remove the am and pm, but this also...
7. Need to return earliest and latest time based on date criteria

I have 4 columns, i want the first two to return the earliest and latest times from two other columns that have date and time (separately). I need a formula that will look at the data based on the date criteria and return the earliest time for that date and another formula to return the latest...
8. hh:mm:ss average problem

hello, I have data that present at hh:mm:ss eg 00:01:52 but when I try to average I get the DIV error and when I try to sum it comes out as 00:00:00 I have tried the different formatting but nothing changes.
9. Flag shifts conflicts on multi-location schedule

Hi There, I have been working on a multilocation (6) weekly scheduling board for 19 employees with some of them having different attributes (notary/supervisor). I would like to make sure the same employee doesn't get schedule at two location for the same time, but sometimes, employees have two...
10. Convert Time into number for Payroll calculations in PowerQuery [Office 2013]

Hey guys. I am doing my first Power Query project using and have successfully transformed data are I wanted that I could not do in PowerPivot. However I need to convert the hours worked by each employees into Number so that I can take that number and use it in the payroll software to calculate...
11. Changing time to 7.5hour days

Hello, I’m wondering if there is a way to change times, such as 158.30, to show the amount of days it adds up to if the days are 7.5 hours long? Thank you
12. Concatenate Date and Time Fields

I have date and time columns (start date/start time and end date/end time) that I am manually concatenating (typing) so that I can calculate a duration. I would like to be able to have a formula do this for me, but a standard concatenate doesn't work. How can I achieve this? START DATE START...
13. Finding instances between time ranges that cross midnight

Hello all, I feel like the answer lies here somewhere, but I'm having difficulty combining the possible answers into one, elegant solution. I'm trying to find the number of instances that a customer comes in to when they leave. I am trying to find out how many customers are present during...
14. Finding Time overlaps with Multiple Criteria

I complete a daily and weekly time sheets for each of my 30 employees. the time is uploaded systemically through our ticketing software by each employee throughout their day. I run the report daily and the time is then sorted by Start Time - smallest to largest, Date - Oldest to Newest and...
15. Working out Time difference

I have the below that I am trying to work out. People have 15:00 minute breaks at present. I have data of how long people have taken. So want to know the difference in time against 15 minutes. Person 1 - 9:53 Person 2 - 20:24 Person 3 - 15:00 Person 4 - 12:30 And so on. At present I get...
16. Counting time from 2 cells if it is between a range

Hi, i'm a newbie in need of urgent help. I have a data set that records meeting occurrences. The start time and end time of the meeting are in a cell each (Rows I and J in the attached image). I am trying to count meeting occurrences looking at half hour intervals. For example if a meeting...
17. Google Sheets (Excel) - Always highlighted sheet?

Would anyone happen to know why every time I go to one specific sheet in the Google Sheets/Excel workbook I'm working on, that particular sheet has all of its cells highlighted? I'm guessing it's something simple I'm missing. Every time I go to that one sheet, even if I click a cell to remove...
18. How to convert Now() to Eastern Standard Time

Hi, I have multiple users across the US using my application and I utilized the now() function. So is there way to convert all of these now() to eastern standard time because these time stamps are saved in my access database. Thanks
19. VBA Target.Address for multiple cells

Hello, I have the below code that works perfectly if you enter/copy data one cell at a time. But I copy/paste multiple cells all the time, at which point the code below gives me an error. Is there a way to adapt the below code to work with multiple cells changing at the same time? Private Sub...
20. Subtracting times, negative result

Hi, I'm sure this is quite simple but I'm not getting it. I want to subtract to time values where the result (in this case) will be negative: Time A is entered manually as e.g. 13:30 Time B is a result of a calculation and shows as 16:00 The result should be -2:30?? I've tried different ways but...

This Week's Hot Topics

• Finding issue in If elseif else with For each Loop
Finding issue in If elseif else with For each Loop I have tried this below code but i'm getting in Y column filled with W005. Colud you please...
• MsgBox Error
Hi Guys, I have the below error show up when i try and run my macro in File1 but works fine if i copy and paste the same code into file2. [ATTACH...
• CELL FORMAT - IF CONDITION
My Cell Format is [B]""0.00" Cr". [/B]But in the cell, it is showing 123.00 for editing. (123 is entry figure). (Data imported from other...
• Show numbers nearly the same
Is this possible. I have a number that can change very time eg 0.00001234 Then I have a lot of numbers 0.0000001, 0.0000002, 0.00000004...