-
How do I find/calculate the available (latest) date from multiple rows WHERE there is a condition
Intent: Calculate date team member is available I have a resource planning sheet, which lists a number of activities (by row) for team members. Each row describes the team member, activity, the status, and the start and end date. How do I find the latest end date for each team member, where there activity is 'In Progress'?…
-
Date+days not calculating correctly
Hi all, I need to add 21 days to a date referenced in another cell. Ex: 10/15/23 When I use this formula: =DATE(YEAR([Projected Start Date]@row), MONTH([Projected Start Date]@row), (DAY([Projected Start Date]@row)) + 21) I receive an #INVALID VALUE If I hardcode the date into the formula (=DATE(2023, 10, 15)+21, I return…
-
Two digit format for hh:mm:ss
Hi all, I researched through numerous posts and threads regarding calculating time but just couldn't figure out one last part. I hope it's an easy one for some experts here. I am trying to calculate the average of a range of time and display it in hh:mm:ss format. By reading through the posts here, I was able to figure out…
-
Calculating Time Duration with In/Out
Hello, I have reviewed several posts on calculating time worked from in/out time entries. I tried to use one of the formulas previously presented (see screenshot), but I keep getting an Invalid Operation error. If it helps, I am trying to calculate time worked using the 12 hour format.
-
Merged: Time Tracking
This discussion has been merged.
-
How do I calculate the sum of a length of time column in the Sheet Summary
I want to be able to calculate the total length of time of all the video files in a sheet for the Sheet Summary. (to then be able to report across multiple sheets, populate in a dashboard etc). These are not formulas and there is also no start or end time as this is the length of a video, not work time. Also, as these are…
-
List of times for meeting agenda?
I'm building a meeting agenda in a sheet, and I wanted to have a start time as the time portion of a date field, and then add durations for each section. Something like: Section Duration Time Intro 5m 9:00 First Item 10m 9:05 Second Item 1h30m 10:35 I formatted the "Duration" column as the duration field type. I wanted the…
-
Show dealy in gantt chart
Hi We are trying to use Gantt chart, for planning a project timeline. We have expected start, actual start, planned end date and actual end date, because sometimes something gets in the way and we can't hold the original timeline. But we want to know how much of a delay we have or doesn't have. So we use the dates to…
