minutes

Hi All, Good day! How can I get the hours or minute difference between two date but those dates should only count network days Fri - 10 sat - 11 sun- 12 mon - 13 <tbody> start date & time end date & time what i get (minutes) desired result (minutes) 8/10/2018 5:08:00 PM 8/13/2018...

eg 0:10-0:11 result as -0:01 minutes

Hi Gurys, I'm hoping someone can assist me. I have used the formula: =INT(C3-B3)&" days "&TEXT(C3-B3,"h"" hrs ""m"" mins """) to return the results as days hours minutes in D3. I now want to tally column D3:D410 to show the total days hours minutes. I am an excel novice, any assistance would...

Hi guys, Ok I have come close with this but my code is heavy and messy so turning to the experts...: So I have a column (let's say C) which has dynamic data (Like stock data) which is updating every second. I'd like to copy column C from row 5 to 1000 (C5:C1000) every 'n' minutes (let's say...

I am trying to find out the number of minutes that have gone by between two different times. The data given to me is presented like this: 1st Date and Time (2 cells) 8/11/2018 06:48:36pm 2nd Date and Time (1 Cell) 08/11/18 06:43p The dates are pretty much irrelevant as they are...

Hi, My head has been pickled trying to figure this out, here's the problem (it's also on google sheets): I am trying to show a live production rate which is based on time and units completed. Start time in the morning is 8am I have a cell which shows the live time beside it Below this I need...

Hello, I recently changed from office 32bit to office 64bit as I had hoped that it would bring an increase in performance. I have one macro that I use regurlarly, it searches through lots of arrays generated from csv data imported to memory. This macro took two and a half minutes te execute on...

Morning everyone, I have a test for you all. I have a schedule of activities that people take part in every day. It is broken up into half an hour slots. e.g. 08:00 - 0830 people do 1,2,3,4 1,2,3 & 4 being 4 different activities, which equates to 7.5 minutes per activity. I'm looking...

In cell E4 I have the formula =IFERROR(A4+TIME(0,D4,0),("")). Where A4 = time and D4 = a number. The formula adds the number to increase the time. Problem: Sometimes the number in column D is a negative but I still want to increase the time by that number, as in treat it like a positive. So I...

Good day! I have a table that looks like <TBODY> Day IN OUT IN OUT Hours 1-Jul 8:00 12:00 13:00 17:00 8 hours, 0 minutes 2-Jul 8:00 12:00 13:00 17:30 8 hours, 30 minutes Total Hours </TBODY> Hours column is formatted as such, h "hours," m "minutes" and is a...

Attempting to create a spread sheet that can calculate the number of minutes an operating room is used on a given shift. I thought I could save a great deal of time by asking here first. An operating room has a certain number of rooms it can use during given shift. So, if I have time period of...

Can anyone help? I'm new to forum and this is defeating me but cannot give up!! I have lots of swimming time data which has been input manually using a decimal instead of a colon between minutes and seconds, how can I convert this? Changing the format to this does not work as some times have...

I am not sure if I am breaking any rules for this forum, but this is just too good to miss. I saw this kid on an American TV show and could not believe it. Here he is in a YouTube clip I found setting a Guinness world record. What does he do? He solves 3 totally mixed Rubik's Cubes in under 5...

2 questions centering around the same report, 2 different ways of getting it and 2 different problems: 1. Report generating from database has total logged time by hh:mm:ss. When I attempt to sum up the time, about 10 cells, each cell reads as a timestamp not as hh:mm:ss. Example: 9:08:50 = 9...

I am trying to add the following Column A1: C1 to get total in Column D1 and can't seem to get it to come out correctly. Please help. Column A1= 1:38 (1hr,38 minutes Column B1= :28 (28minutes) Column C1= :17 (17minutes) Column D1= 2:23 (2hrs, 23 minutes)

I am preparing a dashboard whose first row contains the formula which needs to be dragged down . It takes almost 30 minutes to do a paste special . is there any way to reduce this time . The Sheet has 182 columns and a total of 8000 rows . Takes almost 30 minutes daily.

Hi all. A B C <colgroup><col span="2"><col></colgroup><tbody> 01/06/2018 16:31 01/06/2018 16:42 11 minutes 01/06/2018 16:48 01/06/2018 16:49 a minute 01/06/2018 16:53 01/06/2018 16:54 a minute 04/06/2018 16:44 04/06/2018 16:49 5 minutes...

Hi, I'm trying to set up a conditional format for cells to change colour based on a value in another cell. For example: A2 is a time (06:00). In B2 and C2 there are two different times (07:15 & 07:45). I need the cell that is under 90 minutes (B2) to highlight green and the cell that is over...

I have a document that calculates hours worked for each employee. It then totals all of those hours and minutes. My problem is this: Let's say them total for the day was 111 hours and 6 minutes. The format for the cell is [HH:mm] So then the cell value is 111:06 However, when I copy and paste...

Hi, This is two questions in one, but they're linked: I want to record a time duration in MM:SS into a cell. I've set the format using "custom" and "MM:SS", but to get it to display properly I have to enter zero values for the hour, e.g. 00:10:32 to display 10:32. Is there a way to avoid...