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.
This discussion has been merged.
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…
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…
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…