start

Hello, My employees work on multiple projects, they use excel to record their hours. We currently have 10+ projects but an employee may only be working on any 5 of those. Each employee has their own excel spreadsheet (stored on sharepoint- online 365) I would like to be able to...

I have three shifts that I need to separate hours worked into. Attached is a picture of what I am trying to do it includes the start and end times of the shifts.

I have looked through some of the other questions on here and can't seem to find the answer so hope someone can help me, there is probably a simple fix to my issue and I am showing my limited knowledge regarding the functionality of excel. I have a 24/7 roster that I would like to automatically...

Hi there, I have this VBA Code in my sheet and a module - Option Explicit Dim SchedRecalc As Date Sub Recalc() With Worksheets("Sheet1").Range("B2") .Value = Format(Time, "hh:mm:ss AM/PM") End With Call SetTime End Sub Sub SetTime() SchedRecalc = Now + TimeValue("00:00:01")...

I'm the treasurer of my HOA. I created a budget spreadsheet that works well but I will be giving up the position a some point so I want to create a Dashboard for the person who takes over for me, to make it "user friendly". Every year I have to start with a new sheet, changing the dates...

Hello everyone! I am struggling with a pretty simple problem at the moment. I have the following two tables in the data model (power pivot) tblGeneral ID - Date - Value - Typ: tblWO ID - Date Start - Date Finished - Value - State - Typ ID: ABC Date: DD.MM.YYYY HH:MM:SS Value: 250 Type: X...

I'm trying to display a percentage based on a State Date and End Date. For example: Cell G7 - 6/1/19 (Start Date) Cell H7 - 8/30/19 (End Date) With formula in I7: =IF(H7>TODAY(),(TODAY()/(H7-G7),1) This gives me two conditions I want if the current date exceeds the end date; however, my...

hey i want to learn excel in order to analyze data where should i start? post some vids or books recommendations a begginer

Can anyone tell me how I might do the below multiple part scenario: I need to subtract an end time and a start time to get the hours and the minutes. Start time is in P2 and end time is in Q2. I wanted to do this in a way that I actually don't need to enter the colon and could just enter the...

I have a filed on form that is formatted as currency with a default of zero "0". When the user enters the field to enter an amount, the cursor appears in front of the defaulted value of 0. So when they start entering a value - less say "17" it shows as $170 not $17. When they hit enter it...

I will start this off, I don't program at all, I have been recording and modifying code macros to help automate some things at work. I have this code that's not working when I run it: Columns("C:C").Select ActiveSheet.Range("$C$1:$C$817").AutoFilter Field:=3, Criteria1:="202*"...

I am trying to do a histogram in excel with the bins starting at 0 and each Bin being 0.2 in width. However when i set the bin width at 0.2 it starts the first bin at 0.11 because that is the lowest number in the dataset. how do i get the bin to start at 0 so that that the bins are...

Hi All, I would like a macro to start running automatically as soon as I open the Excel file. However, a prompt would ideally appear first, which asks if the user wants to cancel the automatic start of the macro. The user has the option to click on the prompt (or hit a specific key or...

Hi, I am looking for below. I want to extract reports from web which is having to username and password. How I can start with? Let me know. Nee

I've been toiling with this one for a few hours and have decided to come ask the experts for help. I'm trying to capture the start date associated with a particular company (in sheet 1) from a list of many stages that each company goes through (sheet 2) Sheet 1: unique list of company names...

Hi, I can't accomplish this maybe someone can help. Thanking you in advance. Start time End time 07/05/2019 09:00 07/05/2019 13:40 4.75 08/05/2019 08:58 08/05/2019 13:35 4.5 09/05/2019 09:03 09/05/2019 13:43 4.5 10/05/2019 08:57...

lets say i have a task. i put the start time in excel. i want excel to popup alert me when time is up. how do i do that?

Thank you for taking the time to read. I put together a lot of visit timetables and my issue is they constantly change. For example a visit can start in cell A1 at 09:00 with that section due to finish in cell B1 at 09:20. The next part of the visit could be from cell A2 at 09:20 to cell B2 at...

Hello everybody, hopefully somebody will be able to help. I have drivers who start a job and complete a job. Each job is recorded in our system and extracted in excel format. For example, Job started 10/05/2019 13:34:24 (cell AR414) and Job completed 10/05/2019 14:03:09 (cell AS414), therefore...

I am Daphne from the Netherlands and I have a urgentquestion. I have to make a sheet/formulas for work. I can work with Excel but don’t have the whole knowledge of it. Ok what is my issue. I hope I can explain it correctly in myDutchy/English. Sheets contains personnel names, days, start...