time based formula

I have hit a wall figuring out how to best get this done... Based on this: 5. Employees Normal Work Hours 8:00:00 AM to 4:45:00 PM Date Start Stop Total During Working Hours Total Outside Working Hours 12/1/19 6:30:00 PM 9:30:00 PM NEED THIS VALUE NEED...

Hi All, I am having some trouble adjusting the hours based on Time Zone. For context, I have a dataset where the date / time in column AC is all in EST. I want to adjust this based on Time Zone. In column AK I used =TIME(HOUR(AC2),0,0) to pull out the hour + AM / PM. However, I want to adjust...

Hi guys, I'm struggling with formula, which will count the number of operations "name" did simultaneously, even partially. I'd like to have a 1 or 0 information in new column (1 = the time interval exist, even partially, anywhere else). Data looks like this: <tbody> name start end Mark...

Need to convert something like: 4 Days 16 Hours 32 Minutes to something that can be added up or manipulated. Minutes is fine.

Situation: Simple nested IF statement that looks for time in one column and returns value in another column. Formula: =IF(E46=TIME(3,0,0),I46,IF(E46=TIME(2,0,0),H46,IF(E46=TIME(1,0,0),G46,IF(E46=TIME(0,0,0),AD46,IF(E46=TIME(23,0,0),AC46,AB46))))) Hint: This formula is in column AF Expected...

Hi, I have two columns, one with a date and time (column A) and one with a status (column B). I want a third column(Column C) to say if the date and time in column A is less than today's date and the status in column B is not equal to 'COMPLETED' then move the date to today's date at 07:00:00...

Hello, I am trying to add up the total time differencebetween certain time stamps and when I do, I’m not sure how to convert thenumbers into hours for to get the correct sum. I have tried custom cellformatting but that doesn’t change the way excel sees inside the cell formulas.Below is the table...

Hello - I am trying to derive the MODE of a sequence of times. I have the following format to convert: 12:00:00 EDT I imagine it does need to be converted Into text or number format so as to derive the MODE of this sequence. I have tried several approaches to no avail. I also wish to derive...

Need: A schedule in excel is required for a large team. Schedule gets changed every month and people are rotated (mid person will do the night and night will be moved to morning etc). There are five shifts in a day, each shift having 5 teams and each team having at least 8 members...

Hi, i'm having a hard time working out average pageview times on a website. I've already had a look on a number of posts but nothing seems to work, i've tried right-clicking the data range and formatting to time or custom as hh:mm:ss as my times are displayed as hours mins secs. I've tried the...

Hi all, I have a document that I need to convert large amounts of numbers that have been put into the decimal hours format (e.g. 0.25 hours). But I need to change this to a the number that can be formatted into the excel time formats (e.g. 0.25 hours = 10.2 minutes and or 0.0069444 as a...

Hi Everyone. I am trying to create a worksheet that highlights SLA acceptance and breaches. In Column F, I have the time an Incident is received e.g. 16:05:00 In Column G, I have the time I accepted that incident e.g. 16:10:00 I need the cells in column G to highlight Green if it's within 15...

Is it possible to create a formula that the added time calculated within the working hours? example: if there is on Friday added time, that he does not count weekends stops friday 16u30 but continue from Monday 08u A1 = the added time A2 = the time now + the added time <tbody> A 1...

is it possible to use dates in a formula to activate a formula and then at a designated time stop the formula from working but keep the results of the last recording? I have a report that I pull data from on a monthly basis. what I would like is for the report to automatically pull all the data...

Hi, can anyone help me? I m trying to create a formula that will pull data from a data set but only show the data at the start of a month and then at the end of that month lock the data in place so that another cell will show the data for the next month. the formula I have is as follows...

Hi I need to make an Excel sheet to make an animal observation paper. The list requires to observe the animals every 30 seconds so the list would look something like: 8:25 am 8:25 am 8:26 am 8:26 am 8:27 am 8:27 am etc... Is there a shortcut on how to make these times without having to...

i want to get automated add time for every 00:01:05, example 00:00:00,00:01:05,00:02:10,00:03:15. like this i want upto 5 hours.... example : <tbody> A(original) B (time changed) C ffmpeg -i zxcv.mp4 -ss 00:00:05 -t 00:00:7 -codec copy output.mp4 ffmpeg -i zxcv.mp4 -ss 00:01:10 -t 00:00:7...

Hi Everyone I have a data table that shows a list of times Trailers were tipped, from which site in time order such as <tbody> Date Despatch Site Time of Trailer Unloaded 28/02/2016 MD01 06:13 28/02/2016 KA09 06:56 28/02/2016 MD19 07:42 </tbody> I then on a separate sheet have a...

Hi, I have a report which throws out a column (A) with projected hours and a column (B) with actual hours worked. These figures are in decimal form. I need column C to display A minus B in hrs and mins. My problem is that the values in A and B cannot easily be formatted to hrs and mins. In A1...

Hello All, I am having an issue with accurately counting hours worked. Now, my formulas all work fine until the ending point of a shift reaches the AM. For Example: 6PM - 1AM would be a 7 hour shift, but the result is negative 17 hours. Now I am using two different set of formulas that are...